XlsLoadOptions Class

Represents options for loading from XLS file format (Microsoft Excel Spreadsheet format; Excel 2003 and prior versions) .

public sealed class XlsLoadOptions : LoadOptions

Public NotInheritable Class XlsLoadOptions
    Inherits LoadOptions

Initializes a new instance of the XlsLoadOptions class.

public XlsLoadOptions()

Public Sub New

Gets or sets the password to open protected / encrypted workbook.

public string Password { get; set; }

Public Property Password As String

Gets or sets a value indicating whether to preserve features that are not supported when reading XLS files.

public bool PreserveUnsupportedFeatures { get; set; }

Public Property PreserveUnsupportedFeatures As Boolean

true to preserve features that are not supported when reading XLS files; otherwise, false.

Default value is set to true.

Preserving features in files encrypted with a password is currently not supported.

CsvDefault	Gets the default options for loading from Character Separated Values file format. (Inherited from LoadOptions)
HtmlDefault	Gets the default options for loading from HyperText Markup Language File (HTML) format. (Inherited from LoadOptions)
OdsDefault	Gets the default options for loading from OpenDocument Spreadsheet file format. (Inherited from LoadOptions)
TxtDefault	Gets the default options for loading from Tab delimited file format. (Inherited from LoadOptions)
XlsDefault	Gets the default options for loading from XLS file format (Microsoft Excel Spreadsheet format; Excel 2003 and prior versions) . (Inherited from LoadOptions)
XlsbDefault	Gets the default options for loading from XLSX file format (Microsoft Excel Binary File Format). (Inherited from LoadOptions)
XlsxDefault	Gets the default options for loading from XLSX file format (Microsoft Excel Open XML Spreadsheet; Excel 2007 and later). (Inherited from LoadOptions)
XmlDefault	Gets the default options for loading from XML file format (XML Spreadsheet 2003). (Inherited from LoadOptions)