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

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.
See Also