Worksheet.Protect(String, WorksheetProtectionPermissions) Method

Protects worksheet elements to prevent them from being changed by the user.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v18.2.Core.dll

Declaration

C#

void Protect(
    string password,
    WorksheetProtectionPermissions permissions
)

VB.NET

Sub Protect(
    password As String,
    permissions As WorksheetProtectionPermissions
)

Parameters

Name	Type	Description
password	String	A string that specifies a password for the worksheet. If the password is an empty string, the worksheet can be unprotected without using a password.
permissions	WorksheetProtectionPermissions	A WorksheetProtectionPermissions enumeration that allows you to combine enumeration values to specify multiple worksheet elements to protect.

Remarks

If the worksheet is already protected, the Protect method throws an exception. Check the Worksheet.IsProtected property before calling the method.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/winforms-spreadsheetcontrol-api-part-2-e4832

ProtectionActions.vb

Dim worksheet As Worksheet = workbook.Worksheets(0)

' Protect a worksheet. Prevent users from making changes to worksheet elements.
If Not worksheet.IsProtected Then
    worksheet.Protect("password", WorksheetProtectionPermissions.Default)
End If
workbook.BeginUpdate()
worksheet("C3:F8").Borders.SetOutsideBorders(Color.Red, BorderLineStyle.Thin)
worksheet("D5:E6").Merge()
worksheet("D5").Value = "Try to change me!"
worksheet("D5").Alignment.Vertical = SpreadsheetVerticalAlignment.Center
workbook.EndUpdate()

ProtectionActions.cs

Worksheet worksheet = workbook.Worksheets[0];

// Protect a worksheet. Prevent users from making changes to worksheet elements.
if (!worksheet.IsProtected)
    worksheet.Protect("password", WorksheetProtectionPermissions.Default);
workbook.BeginUpdate();
worksheet["C3:F8"].Borders.SetOutsideBorders(Color.Red, BorderLineStyle.Thin);
worksheet["D5:E6"].Merge();
worksheet["D5"].Value = "Try to change me!";
worksheet["D5"].Alignment.Vertical = SpreadsheetVerticalAlignment.Center;
workbook.EndUpdate();

You can selectively unlock ranges in a protected worksheet. To do this, add a ProtectedRange to the Worksheet.ProtectedRanges collection. You can specify a password to edit the protected range with the ProtectedRange.SetPassword method and give specific users permission to edit the range with the ProtectedRange.CreateSecurityDescriptor method.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Protect(String, WorksheetProtectionPermissions) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

spreadsheet-document-api-examples-part2/CS/SpreadsheetDocServerAPIPart2/CodeExamples/ProtectionActions.cs#L46

if (!worksheet.IsProtected)
    worksheet.Protect("password", WorksheetProtectionPermissions.Default);
// Add a note.

wpf-spreadsheetcontrol-api-part-2-e4944/CS/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/ProtectionActions.cs#L37

if (!worksheet.IsProtected)
    worksheet.Protect("password", WorksheetProtectionPermissions.Default);
workbook.BeginUpdate();

winforms-spreadsheetcontrol-api-part-2-e4832/CS/SpreadsheetControl_API_Part02/SpreadsheetActions/ProtectionActions.cs#L39

if (!worksheet.IsProtected)
    worksheet.Protect("password", WorksheetProtectionPermissions.Default);
workbook.BeginUpdate();

mvc-gridview-how-to-customize-an-exported-dataaware-excel-file-t385649/CS/T385649/Controllers/HomeController.cs#L28

Worksheet aw = mySpreadsheet.Document.Worksheets[0];
aw.Protect("123456", DevExpress.Spreadsheet.WorksheetProtectionPermissions.Default);
byte[] result = mySpreadsheet.SaveCopy(DocumentFormat.Xlsx);

VB.NET

spreadsheet-document-api-examples-part2/VB/SpreadsheetDocServerAPIPart2/CodeExamples/ProtectionActions.vb#L47

If Not worksheet.IsProtected Then
    worksheet.Protect("password", WorksheetProtectionPermissions.Default)
End If

wpf-spreadsheetcontrol-api-part-2-e4944/VB/SpreadsheetControl_WPF_API_Part02/SpreadsheetActions/ProtectionActions.vb#L41

If Not worksheet.IsProtected Then
    worksheet.Protect("password", WorksheetProtectionPermissions.Default)
End If

winforms-spreadsheetcontrol-api-part-2-e4832/VB/SpreadsheetControl_API_Part02/SpreadsheetActions/ProtectionActions.vb#L43

If Not worksheet.IsProtected Then
    worksheet.Protect("password", WorksheetProtectionPermissions.Default)
End If

mvc-gridview-how-to-customize-an-exported-dataaware-excel-file-t385649/VB/T385649/Controllers/HomeController.vb#L28

Dim aw As Worksheet = mySpreadsheet.Document.Worksheets(0)
aw.Protect("123456", DevExpress.Spreadsheet.WorksheetProtectionPermissions.Default)
Dim result() As Byte = mySpreadsheet.SaveCopy(DocumentFormat.Xlsx)