Specifies how the provider determines column data types when reading text files.

Syntax

Connect-CSV -TypeDetectionScheme string

Possible Values

Data Type

cstr

Default Value

"RowScan"

Remarks

This property controls the method that the cmdlet uses to detect column structures and data types.

Available options:

None: All columns are returned as string values. RowScan: The cmdlet scans a sample of rows to infer data types. The RowScanDepth property determines how many rows are scanned. ColumnCount: The cmdlet determines the number of columns to include based on the ColumnCount property, returning all values as strings.

This property is useful for adjusting schema detection based on file structure or performance needs.