Encrypt Decrypt Excel Files using Java

decrypt-excel-file.java

// Initialize loading options
LoadOptions loadOptions = new LoadOptions(LoadFormat.XLSX);

// Set original password
loadOptions.setPassword("1234");

// Instantiate a Workbook object with Excel file's path
Workbook workbook = new Workbook("encrypted-workbook.xlsx", loadOptions);

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

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

encrypt-excel-file.java

// Instantiate a Workbook object by excel file path
Workbook workbook = new Workbook("workbook.xlsx");

// Password protect the file
workbook.getSettings().setPassword("1234");

// Encrypt by specifying the encryption type
workbook.setEncryptionOptions(EncryptionType.XOR, 40);

// Specify Strong Encryption type (RC4,Microsoft Strong Cryptographic Provider)
workbook.setEncryptionOptions(EncryptionType.STRONG_CRYPTOGRAPHIC_PROVIDER, 128);

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

verify-password.java

// Create a Stream object
FileInputStream fstream = new FileInputStream("encrypted-workbook.xlsx");

// Verify password
boolean isPasswordValid = FileFormatUtil.verifyPassword(fstream, "1234");

// Print results
System.out.println("Password is Valid: " + isPasswordValid);