// 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")