|
Worksheet Protection
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.
Sample Code-Worksheet Protection
Worksheet Protection in MS Excel
Essential XlsIO also lets you unlock an existing worksheet when you specify the correct unlock password.
Sample Code-Unprotect Worksheet
Unprotect Worksheet in MS Excel
You can also unlock a specific cell in a protected worksheet which allows the end-user to edit that specific cell.
Sample Code-Unlock Cell
|
|
|
|
