DevExpress.DataAccess.Excel Namespace

Contains classes that support binding to Microsoft Excel data sources.

Assembly: DevExpress.DataAccess.v19.2.dll

Classes

Name Description
BeforeFillEventArgs Provides data for the ExcelDataSource.BeforeFill event.
CsvSourceOptions Contains options used to extract data from the CSV file.
CsvSourceOptions.EncodingConverter
DuplicateNameValidationException The exception thrown during ExcelDataSource.Schema validation when the schema references two or more FieldInfo objects having identical FieldInfo.Name values.
ExcelDataSource The data source that extracts data from Microsoft Excel workbooks or CSV files.
ExcelDefinedNameSettings Contains options used to select data from a range of cells specified using the defined name.
ExcelSchemaProvider A default implementation of the IExcelSchemaProvider service.
ExcelSettingsBase Serves as the base for classes containing settings used to import data from the Microsoft Excel workbook.
ExcelSourceOptions Contains options used to extract data from the Microsoft Excel workbook.
ExcelSourceOptionsBase Serves as the base class for classes used to extract data from Microsoft Excel workbooks (XLS, XLSX or XLSM files) or CSV files.
ExcelTableSettings Contains options used to select data from the specified table.
ExcelWorksheetSettings Contains options used to select data from the specified worksheet.
FieldInfo Contains settings of the ExcelDataSource field.
FieldInfoList Contains the ExcelDataSource schema.
NameIsNullOrEmptyValidationException The exception thrown during ExcelDataSource.Schema validation when the schema references a FieldInfo object without a proper FieldInfo.Name.
SchemaValidationException The base for exceptions thrown when the ExcelDataSource.Schema validation fails.
TypeIsNullValidationException The exception thrown during ExcelDataSource.Schema validation when the schema references a FieldInfo object without a proper FieldInfo.Type.

Interfaces

Name Description
IExcelSchemaProvider When implemented, provides the capability to customize the schema retrieved for an Excel/CSV file.

Enums

Name Description
CsvNewlineType Lists characters used to identify a new line in a CSV document.
ExcelDocumentFormat Lists values that specify the format of the document used to supply the ExcelDataSource with data.