WriteProtectionOptions.IsPasswordProtected Property

Indicates whether a workbook is write-protected.

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

NuGet Package : DevExpress.Spreadsheet.Core

Declaration

C#
VB.NET

csharp

bool IsPasswordProtected { get; }

ReadOnly Property IsPasswordProtected As Boolean

Property Value

Type	Description
Boolean

true if the document requires a password for write access; otherwise, false.

Property Paths

You can access this nested property as listed below:

Object Type	Path to IsPasswordProtected
DocumentSettings

.WriteProtection .IsPasswordProtected

Remarks

The following example demonstrates how to remove protection from a write-protected document:

C#
VB.NET

csharp

using (Workbook workbook = new Workbook())
{
    workbook.LoadDocument("WriteProtectedDocument.xlsx");
    RemoveWriteProtection(workbook);
}
// ...

private void RemoveWriteProtection(Workbook workbook)
{
    if (workbook.DocumentSettings.WriteProtection.IsPasswordProtected)
        workbook.DocumentSettings.WriteProtection.ClearPassword();
}

Using workbook As New Workbook()
    workbook.LoadDocument("WriteProtectedDocument.xlsx")
    RemoveWriteProtection(workbook)
End Using
' ...

Private Sub RemoveWriteProtection(workbook As Workbook)
    If workbook.DocumentSettings.WriteProtection.IsPasswordProtected Then
        workbook.DocumentSettings.WriteProtection.ClearPassword()
    End If
End Sub