TypeDetectionScheme
Determines the method for identifying the data types of columns.
Possible Values
None, RowScan, ColumnFormatData Type
string
Default Value
"RowScan"
Remarks
The connector can detect data types with the cell format (number, currency, date, etc.) or by scanning rows.
| Setting | Result |
| None | Returns all columns as the string type. |
| RowScan | Scans rows to heuristically determine the data type. The RowScanDepth determines the number of rows the connector will scan. |
| ColumnFormat | Reports the data type based on the cell format of the column.
Note: This option is applicable only for the 'UnformattedValue' ValueRenderOption. If the ValueRenderOption is set to 'FormattedValue' or 'Formula', all columns will be exposed as String types. |