//create a new workbook Workbook workbook = new Workbook(); //Load template file Home inventory.xlsx from resource to the source workbook Workbook source_workbook = new Workbook(); InputStream source_fileStream = this.getResourceStream("xlsx/Home inventory.xlsx"); source_workbook.open(source_fileStream); //Copy content of active sheet from source workbook to the current workbook before the first sheet IWorksheet copy_worksheet = source_workbook.getActiveSheet().copyBefore(workbook.getWorksheets().get(0)); copy_worksheet.setName("Copy of Home inventory"); copy_worksheet.activate(); //save to an excel file workbook.save("CopyWorksheetBetweenWorkbooks.xlsx");
//create a new workbook var workbook = Workbook() //Load template file Home inventory.xlsx from resource to the source workbook val source_workbook = Workbook() val source_fileStream = this.getResourceStream("xlsx/Home inventory.xlsx") source_workbook.open(source_fileStream!!) //Copy content of active sheet from source workbook to the current workbook before the first sheet val copy_worksheet = source_workbook.activeSheet.copyBefore(workbook.worksheets.get(0)) copy_worksheet.name = "Copy of Home inventory" copy_worksheet.activate() //save to an excel file workbook.save("CopyWorksheetBetweenWorkbooks.xlsx")