TypeDetectionScheme
Determines how to determine 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.
None | Setting TypeDetectionScheme to None will return all columns as the string type. |
RowScan | Setting TypeDetectionScheme to RowScan will scan rows to heuristically determine the data type. The RowScanDepth determines the number of rows the connector will scan. |
ColumnFormat | Setting TypeDetectionScheme to ColumnFormat will report the data type based on the cell format of the column.
Note: This option is applicable only for the 'UnformattedValue' and 'Formula' ValueRenderOption-s. If the ValueRenderOption is set to 'FormattedValue', all columns will be exposed as String types. |