|
Worksheet Protection
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.
Sample Code
Worksheet Protection in Excel
XlsIO also lets you unlock an existing worksheet, provided you specify the right password for unlocking.
Sample Code
Unprotecting the worksheet in Excel
You can also unlock specific cells in a protected worksheet, to allow the end-user edit those specific cells.
Sample Code
|
|
|
|
