TypeDetectionScheme Parameter (Connect-ExcelOnline Cmdlet)
Determines how to determine the data types of columns.
Syntax
Connect-ExcelOnline -TypeDetectionScheme string
Possible Values
None, RowScan, ColumnFormatData Type
cstr
Default Value
"RowScan"
Remarks
The cmdlet can detect data types with the cell format (number, currency, date, etc.) or by scanning rows.
None | Setting TypeDetectionScheme to None will return all columns as the string type. |
RowScan | Setting TypeDetectionScheme to RowScan will scan rows to heuristically determine the data type. The RowScanDepth determines the number of rows the cmdlet will scan. |
ColumnFormat | Setting TypeDetectionScheme to ColumnFormat will report the data type based on the cell format of the column.
Note: This option is applicable only for the 'UnformattedValue' and 'Formula' ValueRenderOption-s. If the ValueRenderOption is set to 'FormattedValue', all columns will be exposed as String types. |