Encrypt Excel Files in Java

decrypt-excel-file.java

// Create an object of LoadOptions class that represents the options of loading the file.  
LoadOptions loadOptions = new LoadOptions();
// Invoke the setPassword method to set the password of the workbook.  
loadOptions.setPassword("1234");
// Instantiate an instance of the Workbook class and load the xlsx file with options  
Workbook workbook = new Workbook("sample.xlsx", loadOptions);
// Remove the password by setting the password value null.  
workbook.getSettings().setPassword(null);
// Save the file by calling the save method. 
workbook.save("Book1.xlsx");

Encrypt-Excel-Files.Java

// Instantiate a Workbook object and load an Excel file path
Workbook workbook = new Workbook("sample.xlsx");
// Password protect the file by calling the setPassword method.  
workbook.getSettings().setPassword("1234");
// Specify XOR encrption type by setting values of the setEncryptionOptions method. 
workbook.setEncryptionOptions(EncryptionType.XOR, 40);
// Specify Strong Encryption type (RC4,Microsoft Strong Cryptographic Provider).
workbook.setEncryptionOptions(EncryptionType.STRONG_CRYPTOGRAPHIC_PROVIDER, 128);
// Invoke the save to save the Excel file. 
workbook.save(  "EncryptingFiles_out.xls");