TypeDetectionScheme Parameter (Connect-GoogleSheets Cmdlet)
Determines how to determine the data types of columns.
Syntax
Connect-GoogleSheets -TypeDetectionScheme string
Possible Values
None, RowScanData Type
cstr
Default Value
"RowScan"
Remarks
| None | Setting TypeDetectionScheme to None returns all columns as the string type. Note: Even when set to None, the column names are still scanned when Header is set to True. |
| RowScan | Setting TypeDetectionScheme to RowScan scans rows to heuristically determine the data type. The RowScanDepth determines the number of rows to be scanned. Setting this to -1 directs the driver to scan the entire sheet. |