This quick tutorial describes how to open password protected Excel file using Node.js. You will get the environment details to work with this feature, a list of programming steps, and a runnable sample code demonstrating how to open a Excel file that is password protected using Node.js. Various other options will also be discussed to load a workbook using the LoadOptions.
Steps to Open Password Protected Excel using Node.js
- Set the environment to use Aspose.Cells for Node.js via Java to open an encrypted file
- Create an object of the LoadOptions class
- Set the load format to XLSX
- Set the password to open the Excel file
- Open the Workbook using the Excel file name and above load options with the password
The above-mentioned steps define how to open a password protected Excel using Node.js. First, an object of the LoadOptions class is declared and customized by setting the load format to XLSX and the file opening password. Finally, open the password protected Excel file using the file name and the load options.
Code to Open Excel File with Password using Node.js
This code demonstrates how to open a protected Excel file using Node.js. The LoadOptions class has various properties and methods to set different parameters for example, flag to preserve padding spaces in the formula, set the paper size, set language code, set interrupt monitor, and font configuration.
This article has taught us how to open an Excel file with a password using Node.js. If you want to learn to protect an Excel file, refer to the article on how to password protect an Excel file using Node.js.