Back to Devexpress

DevExpress.XtraSpreadsheet.Import Namespace

officefileapi-devexpress-dot-xtraspreadsheet-9a6c1214.md

latest4.0 KB
Original Source

DevExpress.XtraSpreadsheet.Import Namespace

Contains classes specific for spreadsheet document import.

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

NuGet Package : DevExpress.Spreadsheet.Core

Classes

NameDescription
ColumnDataTypeCollectionStores data format settings for columns in the imported CSV or TXT file.
CsvDocumentImporterOptionsContains options used for loading (importing) a document in CSV format.
OpenXmlDocumentImporterOptionsContains options used for loading (importing) a document in OpenXML format (aka MS Excel 2007 default format, .xlsx).
TxtDocumentImporterOptionsContains options used for loading (importing) a document in text format.
WorkbookImportOptionsContains options used for loading (importing) workbooks.
XlsbDocumentImporterOptionsContains options used to load a document in the XLSB format (Microsoft Excel 2007-2010 binary file format).
XlsDocumentImporterOptionsContains options used for loading (importing) a document in XLS format (MS Excel 97-2003 binary file format).
XlsmDocumentImporterOptionsContains options used for loading (importing) a document in OpenXML format with macro support (.xlsm).
XltDocumentImporterOptionsContains options used for loading (importing) a document in the Microsoft Excel 97-2003 Template format (.xlt).
XltmDocumentImporterOptionsContains options used for loading (importing) a macro-enabled template in OpenXML format (.xltm).
XltxDocumentImporterOptionsContains options used for loading (importing) a template in OpenXML format (.xltm).
XmlSpreadsheet2003DocumentImporterOptionsContains options used to load a document as an XML Spreadsheet 2003 file.

Enums

NameDescription
CalculationModeOverrideLists values used to override the calculation mode for a loaded document.
CellReferenceStyleSpecifies the cell reference style.
ColumnDataTypeLists values used to define data formats of columns in the imported CSV or TXT file.
CsvImportCellIndexStrategyLists actions which can be performed when an incorrect column or row index is encountered during import.
CsvValueTypeDetectModeLists levels of complexity used for identifying the type of value.
NewlineTypeLists character sequences used to represent a new line.
WorksheetNameValidationTypeLists rules by which new worksheet names are validated.