DevExpress.DataAccess.Excel Namespace

Contains classes that support binding to Microsoft Excel data sources.

Assembly : DevExpress.DataAccess.v25.2.dll

NuGet Package : DevExpress.DataAccess

Classes

Name	Description
BeforeFillEventArgs	Provides data for the ExcelDataSource.BeforeFill event.
CsvSourceOptions	Contains options used to extract data from the CSV file.
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.