ADO.NET Provider for Microsoft Excel

Build 23.0.8839

TypeDetectionScheme

Determines how the provider detects the data types of columns.

Possible Values

None, RowScan, ColumnFormat, ColumnStyle

Data Type

string

Default Value

"ColumnFormat"

Remarks

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.
ColumnStyleSetting TypeDetectionScheme to ColumnStyle will scan rows to heuristically determine the data type. The RowScanDepth determines the number of rows to be scanned.This will retrieve more specific data types (date / time instead of just timestamp), but is more likely to cause values to be truncated due to values in the cells not completely following the style.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839