WorkbookImportOptions Properties

Contains options used for loading (importing) workbooks.

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.