This sample demonstrates how to encrypt and decrypt workbooks using XlsIO.
Click the button to view an Excel spreadsheet generated by Essential XlsIO. Please
note that Microsoft Excel Viewer or Microsoft Excel is required to view the resultant document.
Save As :
This sample focuses on the encryption and decryption of an Excel 2007, Excel 2010, Excel 2013 and Excel 2016 workbook using Essential XlsIO.
Encryption is a method of protecting workbook data.It is based on a password that converts the data into a form that cannot be understood; it also restricts anonymous users from accessing a document. Decryption is the process of converting encrypted data back into its original form so that data can be read from the workbook.
A password for encrypting a workbook can be set in Microsoft Excel 2007, Excel 2010 and Excel 2013 through the Office Menu->Prepare->Encrypt Document command.
Note: Password protection of a workbook file is different from the workbook structure and window protection you can set in the Review->Protect Workbook