.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+

DevExpress.XtraSpreadsheet.Import Namespace

Contains classes specific for spreadsheet document import.

Assembly: DevExpress.Spreadsheet.v19.2.Core.dll

Classes

Name Description
ColumnDataTypeCollection Stores data format settings for columns in the imported CSV or TXT file.
CsvDocumentImporterOptions Contains options used for loading (importing) a document in CSV format.
OpenXmlDocumentImporterOptions Contains options used for loading (importing) a document in OpenXML format (aka MS Excel 2007 default format, .xlsx).
TxtDocumentImporterOptions Contains options used for loading (importing) a document in text format.
WorkbookImportOptions Contains options used for loading (importing) workbooks.
XlsbDocumentImporterOptions Contains options used to load a document in the XLSB format (Microsoft Excel 2007-2010 binary file format).
XlsDocumentImporterOptions Contains options used for loading (importing) a document in XLS format (MS Excel 97-2003 binary file format).
XlsmDocumentImporterOptions Contains options used for loading (importing) a document in OpenXML format with macro support (.xlsm).
XltDocumentImporterOptions Contains options used for loading (importing) a document in the Microsoft Excel 97-2003 Template format (.xlt).
XltmDocumentImporterOptions Contains options used for loading (importing) a macro-enabled template in OpenXML format (.xltm).
XltxDocumentImporterOptions Contains options used for loading (importing) a template in OpenXML format (.xltm).

Enums

Name Description
CalculationModeOverride Lists values used to override the calculation mode for a loaded document.
CellReferenceStyle Specifies the cell reference style.
ColumnDataType Lists values used to define data formats of columns in the imported CSV or TXT file.
CsvImportCellIndexStrategy Lists actions which can be performed when an incorrect column or row index is encountered during import.
CsvValueTypeDetectMode Lists levels of complexity used for identifying the type of value.
NewlineType Lists character sequences used to represent a new line.
WorksheetNameValidationType Lists rules by which new worksheet names are validated.