DevExpress.DataAccess.Excel Namespace
Contains classes that support binding to Microsoft Excel data sources.
Assembly: DevExpress.DataAccess.v24.1.dll
NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap
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. |