//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); //protect worksheet, allow insert column. worksheet.setProtection(true); worksheet.getProtectionSettings().setAllowInsertingColumns(true); //save to an excel file workbook.save("ProtectWorksheet.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) //protect worksheet, allow insert column. worksheet.protection = true worksheet.protectionSettings.allowInsertingColumns = true //save to an excel file workbook.save("ProtectWorksheet.xlsx")