Protection of Excel Spreadsheets by Adding, Removing, and Changing Password using Java

readme.md

Related Article(s):

• Java - Lock & Unlock Excel Files with Password
• Password Protect Excel Spreadsheets
• Unlock Password Protected Excel Spreadsheets

ChangeSpreadsheetPassword.java

/*
 * Update password of the protected spreadsheet files using Java
 */
LoadOptions loadOptions = new LoadOptions("mySECRETpassWORD");
UpdatePasswordOptions updateOptions = new UpdatePasswordOptions("TOPSECRET_pa22WORD");

Merger merger = new Merger("path/protected-spreadsheet.xlsx", loadOptions);
merger.updatePassword(updateOptions);
merger.save("path/pwd-changed-spreadsheet.xlsx");

PasswordProtectSpreadsheet.java

/*
 * Password Protect Excel Spreadsheets using Java
 */
AddPasswordOptions addOptions = new AddPasswordOptions("mySECRETpassWORD");

Merger merger = new Merger("path/spreadsheet.xlsx");
merger.addPassword(addOptions);
merger.save("path/protected-spreadsheet.xlsx");

RemoveSpreadsheetPassword.java

/*
 * Remove password from Excel Spreadsheet files using Java
 */
LoadOptions loadOptions = new LoadOptions("mySECRETpassWORD");

Merger merger = new Merger("path/protected-spreadsheet.xlsx", loadOptions);
merger.removePassword();
merger.save("path/unlocked-spreadsheet.xlsx");