Specifies how the provider determines the data types of columns in a worksheet.

Possible Values

データ型

string

デフォルト値

"RowScan"

解説

This property controls how the connector determines the data types of columns when reading Excel data.

Available options:

• None: All columns are returned as string values, with no type inference.
• RowScan: The connector scans sample rows to heuristically determine each column’s data type. The number of rows scanned is controlled by the RowScanDepth property.

Use this property when you need to control or bypass automatic data type detection in your worksheet.