DevExpress.XtraSpreadsheet.Import Namespace

Contains classes specific for spreadsheet document import.

Assembly: DevExpress.Spreadsheet.v18.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.
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 calculation modes which can be applied to the loaded document, overriding its settings.
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.