// 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");