Example of Protection in ASP.NET Core Spreadsheet Control

Spreadsheet
Protection

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.

ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAY
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Home Loan Calculator
Loan Amount:$100,000.00
Interest Rate:8.00%
Periods (terms in year):1
Start Date:3/3/2020
Loan EMI:$8,698.84
Number of Payments:12
Total Repayment Amount:$104,386.11
Total Interest Amount:$4,386.11

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.

More information about protect sheet and lock cell feature can be found in this documentation section.

Transform your ASP.NET Core web apps today with Syncfusion® ASP.NET Core components
85+ high-performance and responsive UI components
Dedicated support
Hassle-free licensing
TRY IT FOR FREE
opens in a new tab