Specifies the method for identifying the data types of columns.

Possible Values

データ型

string

デフォルト値

"RowScan"

解説

The 本製品 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 本製品 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.