Cmdlets for Google Sheets

Build 24.0.9060

Sheets

Returns a list of a user's sheets and their relevant information.

Columns

Name Type Description
SpreadsheetId String The assigned Id of the spreadsheet.
SpreadsheetName String The name of the spreadsheet.
SheetId String The assigned Id of the sheet.
SheetName String The name of the sheet.
SheetIndex Integer The index of the sheet within the spreadsheet.
SheetType String The type of sheet. Defaults to GRID.
Hidden Boolean Specifies if the sheet is hidden in the UI or not.
RowCount Integer The number of rows in the grid.
ColumnCount Integer The number of columns in the grid.
FrozenRowCount Integer The number of rows that are frozen in the grid.
FrozenColumnCount Integer The number of columns that are frozen in the grid.
DataSourceExecutionStatus String The execution status of the DataSource sheet

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