//create a new workbook Workbook workbook = new Workbook(); Object data = new Object[][]{ {"Name", "City", "Birthday", "Sex", "Weight", "Height"}, {"Bob", "NewYork", new GregorianCalendar(1968, 5, 8), "male", 80, 180}, {"Betty", "NewYork", new GregorianCalendar(1972, 6, 3), "female", 72, 168}, {"Gary", "NewYork", new GregorianCalendar(1964, 2, 2), "male", 71, 179}, {"Hunk", "Washington", new GregorianCalendar(1972, 7, 8), "male", 80, 171}, {"Cherry", "Washington", new GregorianCalendar(1986, 1, 2), "female", 58, 161}, {"Eva", "Washington", new GregorianCalendar(1993, 2, 5), "female", 71, 180} }; // Set data. IWorksheet sheet = workbook.getWorksheets().get(0); sheet.getRange("A1:F7").setValue(data); sheet.getTables().add(sheet.getRange("A1:F7"), true); //Save csv options CsvSaveOptions options = new CsvSaveOptions(); options.setColumnSeparator("-"); options.setRowSeparator("\r\n"); options.setCellSeparator('"'); //Change the path to real export path when save. workbook.save("dest.csv", options);
//create a new workbook var workbook = Workbook() val data = arrayOf(arrayOf("Name", "City", "Birthday", "Sex", "Weight", "Height"), arrayOf("Bob", "NewYork", GregorianCalendar(1968, 5, 8), "male", 80, 180), arrayOf("Betty", "NewYork", GregorianCalendar(1972, 6, 3), "female", 72, 168), arrayOf("Gary", "NewYork", GregorianCalendar(1964, 2, 2), "male", 71, 179), arrayOf("Hunk", "Washington", GregorianCalendar(1972, 7, 8), "male", 80, 171), arrayOf("Cherry", "Washington", GregorianCalendar(1986, 1, 2), "female", 58, 161), arrayOf("Eva", "Washington", GregorianCalendar(1993, 2, 5), "female", 71, 180)) // Set data. val sheet = workbook.worksheets.get(0) sheet.getRange("A1:F7").value = data sheet.tables.add(sheet.getRange("A1:F7"), true) //Save csv options val options = CsvSaveOptions() options.columnSeparator = "-" options.rowSeparator = "\r\n" options.cellSeparator = '"' //Change the path to real export path when save. workbook.save("dest.csv", options)