// Create a new workbook Workbook workbook = new Workbook(); //Load template file from resource InputStream templateFile = this.getResourceStream("xlsx/CombinedFilter.xlsx"); workbook.open(templateFile); Workbook dataWorkbook = new Workbook(); dataWorkbook.open(this.getResourceStream("data/orderData.xlsx"), OpenFileFormat.Xlsx); // Each sheet in the dataWorkbook is a data source. for (IWorksheet worksheet : dataWorkbook.getWorksheets()) { ITableDataSource datasource = new SheetTable(worksheet); workbook.addDataSource(worksheet.getName(), datasource); } //Invoke to process the template workbook.processTemplate(); workbook.getWorksheets().get(0).getRange("A:F").setColumnWidth(16); workbook.getWorksheets().get(0).getRange("A3").clearComments(); // Save to an excel file workbook.save("CombinedFilter.xlsx");
// Create a new workbook var workbook = Workbook() //Load template file from resource val templateFile = this.getResourceStream("xlsx/CombinedFilter.xlsx") workbook.open(templateFile) val dataWorkbook = Workbook() dataWorkbook.open(this.getResourceStream("data/orderData.xlsx"), OpenFileFormat.Xlsx) // Each sheet in the dataWorkbook is a data source. for (worksheet in dataWorkbook.worksheets) { val datasource = SheetTable(worksheet) workbook.addDataSource(worksheet.name, datasource) } //Invoke to process the template workbook.processTemplate() workbook.worksheets[0].getRange("A:F").columnWidth = 16.0 workbook.worksheets[0].getRange("B3").clearComments() // Save to an excel file workbook.save("CombinedFilter.xlsx")