// Create a new workbook Workbook workbook = new Workbook(); IWorksheet sheet1 = workbook.getActiveSheet(); IWorksheet sheet2 = workbook.getWorksheets().add(); IWorksheet sheet3 = workbook.getWorksheets().add(); // Select sheet2 and sheet3. workbook.getWorksheets().get(new String[] { sheet2.getName(), sheet3.getName() }).select(); // Write names of selected sheets to console for (IWorksheet sheet : workbook.getSelectedSheets()) { System.out.println(sheet.getName()); } // Add sheet1 to selected sheets sheet1.select(false); // Write count of selected sheets to console System.out.println(workbook.getSelectedSheets().getCount()); // Save to an excel file workbook.save("SelectWorksheets.xlsx");
// Create a new workbook var workbook = Workbook() val sheet1: IWorksheet = workbook.getActiveSheet() val sheet2: IWorksheet = workbook.getWorksheets().add() val sheet3: IWorksheet = workbook.getWorksheets().add() // Select sheet2 and sheet3. workbook.getWorksheets().get(arrayOf(sheet2.getName(), sheet3.getName())).select() // Write names of selected sheets to console for (sheet in workbook.getSelectedSheets()) { System.out.println(sheet.getName()) } // Add sheet1 to selected sheets sheet1.select(false) // Write count of selected sheets to console System.out.println(workbook.getSelectedSheets().getCount()) // Save to an excel file workbook.save("SelectWorksheets.xlsx")