// Create a new workbook Workbook workbook = new Workbook(); IWorksheet sheet1 = workbook.getActiveSheet(); sheet1.setName("BYROW"); sheet1.getRange("$B$2").setValue("ETA LAMBDA VS Normal LAMBDA"); sheet1.getRange("$B$2").getFont().setBold(true); ITable table1 = sheet1.getTables().add(sheet1.getRange("$B$5:$E$10"), true); table1.convertToRange(); Object[][] sheet1rngB5E10 = new Object[][] { { "Student", "Math", "English", "Physics"}, { "Tom", 19.0, 23.0, 19.0}, { "Jerry", 21.0, 15.0, 18.0}, { "Mario", 19.0, 22.0, 22.0}, { "Luigi", 17.0, 15.0, 23.0}, { "Galen", 16.0, 22.0, 24.0} }; ITable table2 = sheet1.getTables().add(sheet1.getRange("G5:G10"), true); table2.convertToRange(); ITable table3 = sheet1.getTables().add(sheet1.getRange("G13:G18"), true); table3.convertToRange(); sheet1.getRange("$B$5:$E$10").setValue(sheet1rngB5E10); sheet1.getRange("$G$4").setValue("Normal LAMBDA"); sheet1.getRange("$G$5").setValue("BYROW(C6:E10,LAMBDA(row,SUM(row)))"); sheet1.getRange("$G$5").getFont().setColor(Color.GetBlack()); sheet1.getRange("$G$5").getInterior().setColor(Color.GetWhite()); sheet1.getRange("$G$6").setFormula2("=BYROW(C6:E10,LAMBDA(row,SUM(row)))"); sheet1.getRange("$G$12").setValue("ETA LAMBDA"); sheet1.getRange("$G$13").setValue("BYROW(C6:E10,SUM)"); sheet1.getRange("$G$13").getFont().setColor(Color.GetBlack()); sheet1.getRange("$G$13").getInterior().setColor(Color.GetWhite()); sheet1.getRange("$G$14").setFormula2("=BYROW(C6:E10,SUM)"); // Save to an excel file workbook.save("EtaLambda.xlsx");