The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

DevExpress.XtraSpreadsheet.Import Namespace

Contains classes specific for spreadsheet document import.

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.