WriteProtectionOptions.ClearPassword() Method

Clears the password used to modify a workbook.

Namespace: DevExpress.Spreadsheet

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

NuGet Package: DevExpress.Spreadsheet.Core

NuGet Packages: DevExpress.Spreadsheet.Core, DevExpress.WindowsDesktop.Spreadsheet.Core

Declaration

C#

void ClearPassword()

VB.NET

Sub ClearPassword

Remarks

The following example removes write-protection from a workbook:

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