// 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");
// Create a new workbook var workbook = Workbook() val sheet1 = workbook.activeSheet sheet1.name = "BYROW" sheet1.getRange("\$B$2").value = "ETA LAMBDA VS Normal LAMBDA" sheet1.getRange("\$B$2").font.bold = true val table1 = sheet1.tables.add(sheet1.getRange("\$B$5:\$E$10"), true) table1.convertToRange() val sheet1rngB5E10 = arrayOf( arrayOf("Student", "Math", "English", "Physics"), arrayOf("Tom", 19.0, 23.0, 19.0), arrayOf("Jerry", 21.0, 15.0, 18.0), arrayOf("Mario", 19.0, 22.0, 22.0), arrayOf("Luigi", 17.0, 15.0, 23.0), arrayOf("Galen", 16.0, 22.0, 24.0) ) val table2 = sheet1.tables.add(sheet1.getRange("G5:G10"), true) table2.convertToRange() val table3 = sheet1.tables.add(sheet1.getRange("G13:G18"), true) table3.convertToRange() sheet1.getRange("\$B$5:\$E$10").value = sheet1rngB5E10 sheet1.getRange("\$G$4").value = "Normal LAMBDA" sheet1.getRange("\$G$5").value = "BYROW(C6:E10,LAMBDA(row,SUM(row)))" sheet1.getRange("\$G$5").font.color = Color.GetBlack() sheet1.getRange("\$G$5").interior.color = Color.GetWhite() sheet1.getRange("\$G$6").formula2 = "=BYROW(C6:E10,LAMBDA(row,SUM(row)))" sheet1.getRange("\$G$12").value = "ETA LAMBDA" sheet1.getRange("\$G$13").value = "BYROW(C6:E10,SUM)" sheet1.getRange("\$G$13").font.color = Color.GetBlack() sheet1.getRange("\$G$13").interior.color = Color.GetWhite() sheet1.getRange("\$G$14").formula2 = "=BYROW(C6:E10,SUM)" // Save to an excel file workbook.save("EtaLambda.xlsx")