Back to Devexpress

WorkbookImportOptions Properties

officefileapi-devexpress-dot-xtraspreadsheet-dot-import-dot-workbookimportoptions-dot-underscore-properties.md

latest3.4 KB
Original Source

WorkbookImportOptions Properties

Contains options used for loading (importing) workbooks.

NameDescription
CsvProvides access to options specific for importing documents in CSV format.
FallbackFormatGets or sets the format that is used if no distinct format can be specified or recognized.
OpenXmlProvides access to options specific to importing documents in OpenXml format (aka default MS Excel 2007 format or .xlsx).
PasswordGets or sets a password used to unprotect a password-protected document during import.
ThrowExceptionOnInvalidDocumentSpecifies whether an exception should be thrown when importing an invalid document.
TxtProvides access to options specific to importing documents in TXT format.
WorksheetNameValidationTypeSpecifies how to validate worksheet names when importing workbooks.
XlsProvides access to options specific for importing documents in XLS format (MS Excel 97-2003 binary file format).
XlsbProvides access to options used to import documents in the XLSB format (Microsoft Excel 2007-2010 binary file format).
XlsmProvides access to options specific to importing documents in OpenXML format with macro support.
XlsxProvides access to options specific to importing documents in OpenXml format (aka default MS Excel 2007 format or .xlsx).
XltProvides access to options specific to importing documents from XLT format (Microsoft Excel 97-2003 Template).
XltmProvides access to options specific to importing documents from XLM format (MS Excel macro file format).
XltxProvides access to options specific to importing documents from XLTX format (MS Excel template).
XmlSpreadsheet2003Provides access to options used to import documents in XML Spreadsheet 2003 file format.

See Also

WorkbookImportOptions Class

WorkbookImportOptions Members

DevExpress.XtraSpreadsheet.Import Namespace