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
Set this connection property to one of the following:
| None | Returns all columns as string type. |
| RowScan | Scans rows to determine the data type. The RowScanDepth determines the number of rows that the cmdlet scans when determining the data type. |
| ColumnFormat | Reports the data type based on the cell format (Number, Currency, Date, etc.) of the column. |
| ColumnStyle | Scans rows to determine the data type. The RowScanDepth determines the number of rows to be scanned. This retrieves 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 associated conventions for those types. |