Cmdlets for Microsoft Excel Online

Build 24.0.9060

TypeDetectionScheme Parameter (Connect-ExcelOnline Cmdlet)

Determines how to determine the data types of columns.

Syntax

Connect-ExcelOnline -TypeDetectionScheme string

Possible Values

None, RowScan, ColumnFormat

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.

NoneSetting TypeDetectionScheme to None will return all columns as the string type.
RowScanSetting TypeDetectionScheme to RowScan will scan rows to heuristically determine the data type. The RowScanDepth determines the number of rows the cmdlet will scan.
ColumnFormatSetting 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060