CData ADO.NET Provider for Excel Online 2019J - Online Help

Type Detection Scheme

CData ADO.NET Provider for Excel Online 2019J - Build 19.0.7354

Determines how to determine the data types of columns.






The 本製品 can detect data types with the cell format (number, currency, date, etc.) or by scanning rows.

NoneSetting TypeDetectionScheme to None will return all columns as the string type.
RowScanSetting TypeDetectionScheme to RowScan will scan rows to heuristically determine the data type. The RowScanDepth determines the number of rows the 本製品 will scan.
ColumnFormatSetting TypeDetectionScheme to ColumnFormat will report the data type based on the cell format of the column.

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