WorkbookImportOptions.Password Property

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

Namespace: DevExpress.XtraSpreadsheet.Import

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

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:

Library	Object Type	Path to Password
WinForms Controls	SpreadsheetControlOptions	.Import.Password
Office File API	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.

Note

A complete sample project is available at https://github.com/DevExpress-Examples/how-to-load-and-save-a-password-encrypted-file-t464814

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 snippet (auto-collected from DevExpress Examples) contains a reference 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#

how-to-load-and-save-a-password-encrypted-file-t464814/CS/EncryptionExample/Form1.cs#L38

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

VB.NET

how-to-load-and-save-a-password-encrypted-file-t464814/VB/EncryptionExample/Form1.vb#L41

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