Security

Essential XlsIO has support for securing the content, structure and windows of a Excel workbook and worksheet.

Encryption

While saving workbooks, XlsIO lets you encrypt an xls workbook contet with a password so that the workbook can be opened and decrypted by MS Excel only when the user provides the right password.

XlsIO also lets you specify a password for letting the user modify the contents of a workbook using MS Excel. If the user doesn't provide this password, the workbook becomes read only.

Decryption

While reading existing Xls workbooks, XlsIO lets you specify a password to decrypt an encrypted workbook. If the workbook is protected from being modified, you can also specify a password to unprotect and modify it.

You can also specify a password to make the document writable.

Essential XlsIO lets you protect the workbook's structure or windows. By protecting the structure, you can prevent the user from moving the workbooks around, inserting new ones, etc. By protecting the windows in the workbook, you can control the size of the workbook, etc.

Essential XlsIO has support for protecting an individual worksheet. This prevents the end user from editing the contents of the worksheet, while optionally, letting the end users perform some operations on the worksheet like format cells, etc.

XlsIO also lets you unlock an existing worksheet, provided you specify the right password for unlocking.

You can also unlock specific cells in a protected worksheet, to allow the end-user edit those specific cells.