// Create a new workbook Workbook workbook = new Workbook(); IWorksheet sheet = workbook.getWorksheets().get(0); // Init Data sheet.setName("API Evaluate2"); Object[][] data = new Object[][] { { "Product" }, { "Apple" }, { "Grape" }, { "Pear" }, { "Banana" }, { "Coconut" }, { "Strawberry" }, { "Orange" }, { "Pineapple" } }; sheet.getRange("B3:B11").setValue(data); ITable table = sheet.getTables().add(sheet.getRange("B3:B11"), true); ITable table1 = sheet.getTables().add(sheet.getRange("D3:D11"), true); table.convertToRange(); table1.convertToRange(); sheet.getRange("D3").setValue("Evaluate2 results:"); sheet.getRange("B:D").autoFit(); Object evaluateRes = sheet.evaluate2("=LEN(B4:B11)"); sheet.getRange("D4:D11").setValue(evaluateRes); // Save to an excel file workbook.save("Evaluate2.xlsx");
// Create a new workbook var workbook = Workbook() val sheet = workbook.worksheets[0] // Init Data sheet.name = "API Evaluate2" val data = arrayOf( arrayOf("Product"), arrayOf("Apple"), arrayOf("Grape"), arrayOf("Pear"), arrayOf("Banana"), arrayOf("Coconut"), arrayOf("Strawberry"), arrayOf("Orange"), arrayOf("Pineapple") ) sheet.getRange("B3:B11").value = data val table = sheet.tables.add(sheet.getRange("B3:B11"), true) val table1 = sheet.tables.add(sheet.getRange("D3:D11"), true) table.convertToRange() table1.convertToRange() sheet.getRange("D3").value = "Evaluate2 results:" sheet.getRange("B:D").autoFit() val evaluateRes: Any = sheet.evaluate2("=LEN(B4:B11)") sheet.getRange("D4:D11").value = evaluateRes // Save to an excel file workbook.save("Evaluate2.xlsx")