Protect and Unprotect Excel Files in Java

protect-workbook.java

// Open the Excel file
Workbook workbook = new Workbook("workbook.xlsx");

// Protect workbook by specifying protection type
workbook.protect(ProtectionType.ALL, "12345");

// Save the file
workbook.save("workbook_protected.xlsx");

protect-worksheet.java

// Open the Excel file
Workbook workbook = new Workbook("workbook.xlsx");

// Accessing the first worksheet in the Excel file
WorksheetCollection worksheets = workbook.getWorksheets();
Worksheet worksheet = worksheets.get(0);

Protection protection = worksheet.getProtection();

// The following 3 methods are only for Excel 2000 and earlier formats
protection.setAllowEditingContent(false);
protection.setAllowEditingObject(false);
protection.setAllowEditingScenario(false);

// Protect the first worksheet with a password "1234"
protection.setPassword("1234");

// Save the file
workbook.save("Excel.xlsx");

unprotect-workbook.java

// Open the Excel file
Workbook workbook = new Workbook("workbook_protected.xlsx");

// Unprotect workbook
workbook.unprotect("12345");

// Set password to null
workbook.getSettings().setPassword(null);

// Save the file
workbook.save("workbook_unprotected.xlsx");

unprotect-worksheet.java

// Open the Excel file
Workbook workbook = new Workbook("workbook.xlsx");

// Accessing the first worksheet in the Excel file
WorksheetCollection worksheets = workbook.getWorksheets();
Worksheet worksheet = worksheets.get(0); 

// Unprotect worksheet
worksheet.unprotect("12345");

// Save the file
workbook.save("workbook_updated.xlsx");