// Create a new workbook Workbook workbook = new Workbook(); //Load template file Simple invoice.xlsx from resource workbook.open(this.getResourceStream("xlsx/Simple invoice.xlsx")); IWorksheet worksheet = workbook.getActiveSheet(); // fill some new items worksheet.getRange("E09:H09").setValue(new Object[]{"DD1-001", "Item 3", 5.60, 12}); worksheet.getRange("E10:H10").setValue(new Object[]{"DD2-001", "Item 3", 8.5, 14}); worksheet.getRange("E11:H11").setValue(new Object[]{"DD3-001", "Item 3", 9.6, 16}); // Save to an excel file workbook.save("SimpleInvoice.xlsx");
// Create a new workbook var workbook = Workbook() //Load template file Simple invoice.xlsx from resource workbook.open(this.getResourceStream("xlsx/Simple invoice.xlsx")!!) val worksheet = workbook.activeSheet // fill some new items worksheet.getRange("E09:H09").value = arrayOf("DD1-001", "Item 3", 5.60, 12) worksheet.getRange("E10:H10").value = arrayOf("DD2-001", "Item 3", 8.5, 14) worksheet.getRange("E11:H11").value = arrayOf("DD3-001", "Item 3", 9.6, 16) // Save to an excel file workbook.save("SimpleInvoice.xlsx")