TypeDetectionScheme Parameter (Connect-Excel Cmdlet)
Determines how the provider detects the data types of columns.
Syntax
Connect-Excel -TypeDetectionScheme string
Possible Values
None, RowScan, ColumnFormat, ColumnStyleData Type
cstr
Default Value
"ColumnFormat"
Remarks
| None | Setting TypeDetectionScheme to None will return all columns as string type. |
| RowScan | Setting TypeDetectionScheme to RowScan will scan rows to heuristically determine the data type. The RowScanDepth determines the number of rows to be scanned. |
| ColumnFormat | Setting TypeDetectionScheme to ColumnFormat will report the data type based on the cell format (Number, Currency, Date, etc.) of the column. |
| ColumnStyle | Setting TypeDetectionScheme to ColumnStyle will scan rows to heuristically determine the data type. The RowScanDepth determines the number of rows to be scanned.This will retrieve more specific data types (date / time instead of just timestamp), but is more likely to cause values to be truncated due to values in the cells not completely following the style. |