ExcelSchemaProvider.TestRowCount Property

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

Namespace: DevExpress.DataAccess.Excel

Assembly: DevExpress.DataAccess.v23.2.dll

NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap

Declaration

C#

public virtual int TestRowCount { get; }

VB.NET

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.