• Material
  • Fabric
  • Bootstrap
  • Bootstrap v4
  • High Contrast
Theme Selection
Mode Selection
*Translated by Google Translator.

Example of Worksheet Protection in ASP.NET MVC XlsIO Control

This sample demonstrates how to Lock and Unlock spreadsheets using XlsIO.
Click the button to view an Excel spreadsheet generated by Essential XlsIO. Please note that Microsoft Excel Viewer or Microsoft Excel is required to view the resultant document.

Save As :

Microsoft Excel offers a special way for protecting specific data and certain worksheets with or without a password. This prevents anyone from changing, moving, or deleting important data.

Excel allows you to edit or lock a range of cells in a protected worksheet by using the Protection tab in the Format Cells dialog. By default, all cells are locked, but they are not hidden when the worksheet is protected. Worksheets can be protected by choosing the Tools - Protection - Protect Sheet option in Excel.