Specifies the method for identifying the data types of columns.

Possible Values

Data Type

string

Default Value

"RowScan"

Remarks

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

Allowed values are:

• None: Returns all columns as the string type.
• RowScan: Scans rows to heuristically determine the data type. The RowScanDepth property determines the number of rows the provider scans.
• ColumnFormat: Reports the data type based on the cell format of the column.

  Note: This option is applicable only when ValueRenderOption is set to UnformattedValue. If ValueRenderOption is set to FormattedValue or Formula, all columns are exposed as string types.