Security

Essential XlsIO has support for securing the content, structure and window of an MS Excel workbook or worksheet.

Encryption

While saving workbooks, Essential XlsIO lets you encrypt an XLS workbook content with a password. The workbook can be opened and decrypted by MS Excel only when the user provides the right password.

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

Decryption

While reading existing XLS workbooks, Essential 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 a workbook's structure or window. By protecting the structure you can prevent the user from moving or inserting workbooks. By protecting the window in a workbook you can control the size of the workbook.

Essential XlsIO supports protection of individual worksheets. This prevents the end-user from editing contents of the worksheet. Options are avaliable to allow the end-user to perform some operations on the worksheet such as format cells.

Essential XlsIO also lets you unlock an existing worksheet when you specify the correct unlock password.

You can also unlock a specific cell in a protected worksheet which allows the end-user to edit that specific cell.