Cmdlets for Google Sheets

Build 24.0.9060

Orientation Parameter (Connect-GoogleSheets Cmdlet)

Indicates whether the data in the sheet is laid out horizontally or vertically.

Syntax

Connect-GoogleSheets -Orientation string

Possible Values

Horizontal, Vertical

Data Type

cstr

Default Value

"Vertical"

Remarks

HorizontalSpecifies that the cmdlet operates on the rows of a sheet.
VerticalSpecifies that the cmdlet operates on the columns of a sheet.

By default, the cmdlet models vertically oriented spreadsheet data -- rows arranged vertically below a header row.

Set this to "Horizontal" if the rows are arranged left to right. The first column contains the column names and subsequent columns become rows.

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