XlsDocumentImporterOptions.Password Property

Gets or sets the password to load an encrypted workbook. Use the WorkbookImportOptions.Password property instead.

Namespace: DevExpress.XtraSpreadsheet.Import

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

Declaration

C#

[DefaultValue("")]
[Browsable(false)]
public string Password { get; set; }

VB.NET

<DefaultValue("")>
<Browsable(False)>
Public Property Password As String

Property Value

Type	Default	Description
String	String.Empty	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.Xlt.Password
Office File API	DocumentOptions	.Import.Xlt.Password
	WorkbookImportOptions	.Xlt.Password

Remarks

Use the WorkbookImportOptions.Password property instead. That property works for binary .xls as well as for OpenXml .xlsx files. For an example of use refer to the How to: Open and Save a Password Encrypted File article.

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-open-a-password-protected-xls-file-t162440/CS/PasswordToOpenSample/Form1.cs#L27

if (form.ShowDialog() == System.Windows.Forms.DialogResult.OK) {
    spreadsheetControl1.Options.Import.Xls.Password = form.Password;
    spreadsheetControl1.LoadDocument(sourceUri);

VB.NET

how-to-open-a-password-protected-xls-file-t162440/VB/PasswordToOpenSample/Form1.vb#L29

If form.ShowDialog() = System.Windows.Forms.DialogResult.OK Then
    spreadsheetControl1.Options.Import.Xls.Password = form.Password
    spreadsheetControl1.LoadDocument(sourceUri)