This sample demonstrates protect sheet and protect workbook with EMI calculation scenario as an example. To unprotect the sheet, click the unprotect sheet button in the Data tab. Meanwhile, to unprotect the workbook, click the unprotect workbook button in the data tab and provide the password as spreadsheet in the dialog box.
Protect sheet helps you to prevent the users from modifying the data in the spreadsheet. Protect workbook helps you to protect the workbook with a password. In this demo, the `EMI Schedule` sheet is locked using isProtected property inside the `Sheet` property and protect the workbook with a password using password property.
Key Features
- Sheet protection - Protect worksheets from unauthorized editing, formatting, insertion, deletion, and other modifications using sheet protection settings.
- Workbook protection - Secure workbook structure with password protection to restrict sheet-level operations such as inserting, deleting, renaming, moving, hiding, and unhiding worksheets.
- Selective editing and read-only support - Unlock specific cells or ranges in protected sheets and configure rows, columns, or cell ranges as read-only without protecting the entire worksheet.
- Protection management - Protect and unprotect sheets or workbooks through the user interface or programmatically using dedicated Spreadsheet APIs.
Learn how to lock sheets and workbook structure using password-based protection, as demonstrated in this sample.
Documentation Links
More Resource