.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

WorkbookImportOptions Members

Contains options used for loading (importing) workbooks.

Constructors

Name Description
WorkbookImportOptions() Initializes a new instance of the WorkbookImportOptions class with the default settings.

Properties

Name Description
Csv Provides access to options specific for importing documents in CSV format.
FallbackFormat Gets or sets the format that is used if no distinct format can be specified or recognized.
OpenXml Provides access to options specific to importing documents in OpenXml format (aka default MS Excel 2007 format or .xlsx).
Password Gets or sets a password used to unprotect a password-protected document during import.
ThrowExceptionOnInvalidDocument Specifies whether an exception should be thrown when importing an invalid document.
Txt Provides access to options specific to importing documents in TXT format.
WorksheetNameValidationType Specifies how to validate worksheet names when importing workbooks.
Xls Provides access to options specific for importing documents in XLS format (MS Excel 97-2003 binary file format).
Xlsb Provides access to options used to import documents in the XLSB format (Microsoft Excel 2007-2010 binary file format).
Xlsm Provides access to options specific to importing documents in OpenXML format with macro support.
Xlsx Provides access to options specific to importing documents in OpenXml format (aka default MS Excel 2007 format or .xlsx).
Xlt Provides access to options specific to importing documents from XLT format (Microsoft Excel 97-2003 Template).
Xltm Provides access to options specific to importing documents from XLM format (MS Excel macro file format).
Xltx Provides access to options specific to importing documents from XLTX format (MS Excel template).
XmlSpreadsheet2003 Provides access to options used to import documents in XML Spreadsheet 2003 file format.

Methods

Name Description
Assign(BaseOptions) Copies all settings from the options object passed as a parameter. Inherited from BaseOptions.
BeginUpdate() Locks the BaseOptions object by disallowing visual updates until the EndUpdate or CancelUpdate method is called. Inherited from BaseOptions.
CancelUpdate() Unlocks the BaseOptions object after it has been locked by the BeginUpdate method, without causing an immediate visual update. Inherited from BaseOptions.
EndUpdate() Unlocks the BaseOptions object after a call to the BeginUpdate method and causes an immediate visual update. Inherited from BaseOptions.
Equals(Object) Determines whether the specified object is equal to the current object. Inherited from Object.
Equals(Object, Object) static Determines whether the specified object instances are considered equal. Inherited from Object.
GetHashCode() Serves as the default hash function. Inherited from Object.
GetType() Gets the Type of the current instance. Inherited from Object.
MemberwiseClone() protected Creates a shallow copy of the current Object. Inherited from Object.
ReferenceEquals(Object, Object) static Determines whether the specified Object instances are the same instance. Inherited from Object.
ToString() Returns a string representing the currently enabled options. Inherited from BaseOptions.
See Also