officefileapi-devexpress-dot-spreadsheet-dot-workbook-dot-unprotect-x28-system-dot-string-x29.md
Removes protection from a workbook.
You need a license for the DevExpress Office File API Subscription or DevExpress Universal Subscription to use this method in production code.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Docs.v25.2.dll
NuGet Package : DevExpress.Document.Processor
public bool Unprotect(
string password
)
Public Function Unprotect(
password As String
) As Boolean
| Name | Type | Description |
|---|---|---|
| password | String |
A string that specifies the password with which the workbook is protected.
|
| Type | Description |
|---|---|
| Boolean |
true if protection is successfully removed; otherwise, false.
|
If the workbook is not protected, the Unprotect method raises an exception. Use the Workbook.IsProtected property to check whether the workbook is already protected.
Worksheet worksheet = workbook.Worksheets["ProtectionSample"];
workbook.Worksheets.ActiveWorksheet = worksheet;
// Unprotect the workbook (requires the password).
if (workbook.IsProtected)
workbook.Unprotect("password");
// Add a note.
worksheet["B2"].Value = "Workbook is unprotected. Workheets can be added, moved or deleted.";
worksheet.Visible = true;
Dim worksheet As Worksheet = workbook.Worksheets("ProtectionSample")
workbook.Worksheets.ActiveWorksheet = worksheet
' Unprotect the workbook using a password.
If workbook.IsProtected Then
workbook.Unprotect("password")
End If
' Add a note.
worksheet("B2").Value = "Workbook is unprotected. Workheets can be added, moved or deleted."
worksheet.Visible = True
The following code snippet (auto-collected from DevExpress Examples) contains a reference to the Unprotect(String) 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.
if (workbook.IsProtected)
workbook.Unprotect("password");
// Add a note.
If workbook.IsProtected Then
workbook.Unprotect("password")
End If
See Also