• Material
  • Fabric
  • Bootstrap
  • Bootstrap v4
  • High Contrast
Theme Selection
Mode Selection
Essential JS 2
All Controls


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


  • Encrypting with a password
  • Decrypting with a password