DevExpress.DataAccess.Excel Namespace
Contains classes that support binding to Microsoft Excel data sources.
Assembly: DevExpress.DataAccess.v23.2.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. |
| 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. |