Type Detection Scheme
Determines how the provider detects the data types of columns.
Data Type
string
Default Value
"ColumnFormat"
Remarks
None | Setting TypeDetectionScheme to None will return all columns as string type. |
RowScan | Setting TypeDetectionScheme to RowScan will scan rows to heuristically determine the data type. The RowScanDepth determines the number of rows to be scanned. |
ColumnFormat | Setting TypeDetectionScheme to ColumnFormat will report the data type based on the cell format (Number, Currency, Date, etc.) of the column. |