Cmdlets for Google Sheets

Build 24.0.9060

RowScanDepth Parameter (Connect-GoogleSheets Cmdlet)

The maximum number of rows to scan to look for the columns available in a table.

Syntax

Connect-GoogleSheets -RowScanDepth int

Data Type

int

Default Value

50

Remarks

The columns in a table must be determined by scanning table rows. This value determines the maximum number of rows that will be scanned.

Setting a high value may decrease performance. Setting a low value may prevent the data type from being determined properly, especially when there is null data.

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