Excel API Library for Java - Sample Browser | Document Solutions | Save workbook to csv file
[
フレーム]
src="bundle.js">
Refer to the following example code to see how to save a workbook to csv file.
// 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);
// Save to an csv file
workbook.save("SaveWorkbookToCsvFile.csv");
// 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
// Save to an csv file
workbook.save("SaveWorkbookToCsvFile.csv")