Specifies the method for identifying the data types of columns.

Syntax

Connect-ExcelOnline -TypeDetectionScheme string

Possible Values

Data Type

cstr

Default Value

"RowScan"

Remarks

The cmdlet can detect data types with the cell format (number, currency, date, etc.) or by scanning rows.

Allowed values are:

• None: Returns all columns as the string type.
• RowScan: Scans rows to heuristically determine the data type. The RowScanDepth property determines the number of rows the cmdlet scans.
• ColumnFormat: Reports the data type based on the cell format of the column.

  Note: This option is applicable only when ValueRenderOption is set to UnformattedValue. If ValueRenderOption is set to FormattedValue or Formula, all columns are exposed as string types.