GetCellRange
Google Spreadsheet: Get a specified range of cells from a Google worksheet.
Input
| Name | Type | Description |
| ID | String |
The ID of this worksheet. This can be obtained from the ListWorksheets stored procedure. If you know the ID, enter it to avoid the extra requests to the server. If left empty, the spreadsheet and worksheet names are required. |
| Name | String |
The spreadsheet name. |
| Range | String |
The cell range you want to get (i.e. 'A1:C4', 'A1'). If the range is not specified all cells will be returned. |
| SheetName | String |
The worksheet name. |
Output
| Name | Type | Description |
| ggl* | String | Values of the cells within the specified range. Names of the output parameters will be the columns (i.e. a,b,c...aa,ab,ab...). |