WorkbookImportOptions.Password Property

Gets or sets a password used to unprotect a password-protected document during import.

Namespace: DevExpress.XtraSpreadsheet.Import

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public string Password { get; set; }

VB.NET

Public Property Password As String

Property Value

Type	Description
String	A string value that specifies the password.

Property Paths

You can access this nested property as listed below:

Object Type	Path to Password
DocumentOptions	.Import .Password

Remarks

The Password property specifies a password for opening a password-encrypted document.

Example

The code snippet below demonstrates how to use the WorkbookImportOptions.Password property.

View Example

Form1.cs

spreadsheetControl1.Options.Import.Password = "123";
spreadsheetControl1.LoadDocument(documentName);

Form1.vb

spreadsheetControl1.Options.Import.Password = "123"
spreadsheetControl1.LoadDocument(documentName)

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Password property.

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#

winforms-spreadsheet-load-and-save-a-password-encrypted-files/CS/EncryptionExample/Form1.cs#L38

#region #OptionsImportPassword
spreadsheetControl1.Options.Import.Password = "123";
spreadsheetControl1.LoadDocument(documentName);

VB.NET

winforms-spreadsheet-load-and-save-a-password-encrypted-files/VB/EncryptionExample/Form1.vb#L39

#Region "#OptionsImportPassword"
            spreadsheetControl1.Options.Import.Password = "123"
            spreadsheetControl1.LoadDocument(documentName)

spreadsheet-document-api-encryption/VB/EncryptionExample/Program.vb#L14

Dim workbook As Workbook = New Workbook()
workbook.Options.Import.Password = "123"
workbook.LoadDocument("Documents\encrypted.xlsx")