Encrypt Decrypt Excel Files in Node.js

readme.md

Learn how to encrypt and decrypt Excel fils in Node.js: https://blog.aspose.com/2021/10/14/encrypt-or-decrypt-excel-files-in-node-js/

decrypt-excel-file.js

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

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

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

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

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

encrypt-excel-file.js

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

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

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

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