ADO.NET Provider for Excel

Build 20.0.7655

Type Detection Scheme

Determines how the provider detects the data types of columns.

Data Type


Default Value



NoneSetting TypeDetectionScheme to None will return all columns as string type.
RowScanSetting TypeDetectionScheme to RowScan will scan rows to heuristically determine the data type. The RowScanDepth determines the number of rows to be scanned.
ColumnFormatSetting TypeDetectionScheme to ColumnFormat will report the data type based on the cell format (Number, Currency, Date, etc.) of the column.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7655