Skip to main content

ExcelSchemaProvider Class

A default implementation of the IExcelSchemaProvider service.

Namespace: DevExpress.DataAccess.Excel

Assembly: DevExpress.DataAccess.v22.2.dll

NuGet Package: DevExpress.DataAccess


public class ExcelSchemaProvider :


This service prepares schema for an ExcelDataSource using the following settings:

  • TestRowCount

    Specifies the count of rows used to determine the column’s type. The GetSchema method sets a column type to the rows’ type if it is unique. Otherwise, string is set as the column’s type.

  • ColumnBaseName

    Used to generate a column name in the following format: ColumnBaseName + column index.

You can inherit from the ExcelSchemaProvider class to provide custom settings for Excel data source schema generation. The following code demonstrates how to do this:

public class CustomExcelSchemaProvider : DevExpress.DataAccess.Excel.ExcelSchemaProvider {
    public override int TestRowCount {
        get { return 5; }
    public override int ColumnBaseName {
        get { return "MyColumn"; }

The following code demonstrates how to register a custom Excel schema provider:

using DevExpress.DataAccess.Excel;

private SqlDataSource BindToData() {
    var excelDataSource = new ExcelDataSource("Excel Data Source");
    excelDataSource.FileName = HostingEnvironment.MapPath(@"~/App_Data/ExcelDataSource.xlsx");
    var worksheetSettings = new ExcelWorksheetSettings("SalesPerson", "A1:L2000");
    excelDataSource.SourceOptions = new ExcelSourceOptions(worksheetSettings);

    var serviceContainer = (System.ComponentModel.Design.IServiceContainer)excelDataSource;
    serviceContainer.AddService(typeof(DevExpress.DataAccess.Excel.IExcelSchemaProvider), new CustomExcelSchemaProvider());



See Also