//create a new workbook Workbook workbook = new Workbook(); //Open csv with more settings. CsvOpenOptions options = new CsvOpenOptions(); options.setColumnSeparator(","); options.setRowSeparator("\r\n"); options.setCellSeparator('"'); //Change the path to the real file path when open. workbook.open("source.csv", options);
//create a new workbook var workbook = Workbook() //Open csv with more settings. val options = CsvOpenOptions() options.columnSeparator = "," options.rowSeparator = "\r\n" options.cellSeparator = '"' //Change the path to the real file path when open. workbook.open("source.csv", options)