// Create a new workbook Workbook workbook = new Workbook(); Object data = new Object[][]{ {"Name", "City", "Birthday", "Eye color", "Weight", "Height"}, {"Richard", "New York", new GregorianCalendar(1968, 5, 8), "Blue", 67, 165}, {"Nia", "New York", new GregorianCalendar(1972, 6, 3), "Brown", 62, 134}, {"Jared", "New York", new GregorianCalendar(1964, 2, 2), "Hazel", 72, 180}, {"Natalie", "Washington", new GregorianCalendar(1972, 7, 8), "Blue", 66, 163}, {"Damon", "Washington", new GregorianCalendar(1986, 1, 2), "Hazel", 76, 176}, {"Angela", "Washington", new GregorianCalendar(1993, 1, 15), "Brown", 68, 145} }; IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("A1:F7").setValue(data); worksheet.getRange("A:F").setColumnWidth(15); // add table. worksheet.getTables().add(worksheet.getRange("A1:F7"), true); // show totals worksheet.getTables().get(0).setShowTotals(true); worksheet.getTables().get(0).getColumns().get(4).setTotalsCalculation(TotalsCalculation.Average); worksheet.getTables().get(0).getColumns().get(5).setTotalsCalculation(TotalsCalculation.Average); IComment comment = worksheet.getRange("F8").addComment("Please press F9 to calculate the formula."); comment.setVisible(true); // set calculation mode to manual workbook.getOptions().getFormulas().setCalculationMode(CalculationMode.Manual); // Save to an excel file workbook.save("CalculationOptions.xlsx");
// Create a new workbook var workbook = Workbook() val data: Any = arrayOf( arrayOf("Name", "City", "Birthday", "Eye color", "Weight", "Height"), arrayOf("Richard", "New York", GregorianCalendar(1968, 5, 8), "Blue", 67, 165), arrayOf("Nia", "New York", GregorianCalendar(1972, 6, 3), "Brown", 62, 134), arrayOf("Jared", "New York", GregorianCalendar(1964, 2, 2), "Hazel", 72, 180), arrayOf("Natalie", "Washington", GregorianCalendar(1972, 7, 8), "Blue", 66, 163), arrayOf("Damon", "Washington", GregorianCalendar(1986, 1, 2), "Hazel", 76, 176), arrayOf("Angela", "Washington", GregorianCalendar(1993, 1, 15), "Brown", 68, 145) ) val worksheet = workbook.worksheets[0] worksheet.getRange("A1:F7").value = data worksheet.getRange("A:F").columnWidth = 15.0 // add table. worksheet.tables.add(worksheet.getRange("A1:F7"), true) // show totals worksheet.tables[0].showTotals = true worksheet.tables[0].columns[4].totalsCalculation = TotalsCalculation.Average worksheet.tables[0].columns[5].totalsCalculation = TotalsCalculation.Average val comment = worksheet.getRange("F8").addComment("Please press F9 to calculate the formula.") comment.visible = true // set calculation mode to manual workbook.options.formulas.calculationMode = CalculationMode.Manual // Save to an excel file workbook.save("CalculationOptions.xlsx")