ExcelSchemaProvider.TestRowCount Property

Specifies the count of rows used to determine a column's type.

Namespace: DevExpress.DataAccess.Excel

Assembly: DevExpress.DataAccess.v20.1.dll

Declaration

public virtual int TestRowCount { get; }
Public Overridable ReadOnly Property TestRowCount As Integer

Property Value

Type Description
Int32

An integer value specifying the number of rows used to determine a column's type.

Remarks

The ExcelSchemaProvider.GetSchema method gets the column rows' type and, if it is the same for all the rows, assigns it as a column type. Otherwise, string is set as the column's type. The TestRowCount property specifies the number of rows used to determine the column's type.

When inheriting from the ExcelSchemaProvider class, override this property to set a custom number of rows used to determine a column's type. By default, 10 rows take part in a column type determination.

See Also