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 |