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

Syntax

Connect-ExcelServices -TypeDetectionScheme string

Possible Values

Data Type

cstr

Default Value

"RowScan"

Remarks

This property controls how the 本製品 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 本製品 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.