In this section you will find information that will help you to better understand the object model and the functionalities of the Infragistics Excel Engine.
In order to get you up and running as quickly as possible with the Infragistics Excel Engine, this topic provides procedural instructions on how to create a workbook.
The workbook protection feature allows you to protect (with or without password) the following user operations:
Window protection: the ability to resize the MDI child window of the workbook for legacy versions of MS Excel which were displaying each workbook in a separate child window.
Workbook structure: the ability to add, rename, delete, hide and reorder the worksheets.
Note
Note
The protection is not enforced via the Infragistics Excel Engine's object model. It is a responsibility of the UI visualizing this object model, to honor these protection settings and allow or restrict the user from performing the corresponding operations.
Configuration chart
The following table explains briefly the functional aspects of the workbook protection feature and maps them to the properties and methods that operate with them.
Operation
Details
Property/Method
Set workbook protection
You can use the overloads of the Protect method to protect the workbook with password (supplied using string or SecureString) or without password. The other arguments of this method are used to specify each protection setting described above.