WriteProtectionOptions.IsPasswordProtected Property

Indicates whether a workbook is write-protected.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

bool IsPasswordProtected { get; }

VB.NET

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#

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();
}

VB.NET

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