TypeDetectionScheme Parameter (Connect-ExcelServices Cmdlet)
Determines how to determine the data type of columns.
Syntax
Connect-ExcelServices -TypeDetectionScheme string
Possible Values
None, RowScanData Type
cstr
Default Value
"RowScan"
Remarks
| 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 to be scanned. |