Google Sheets — Read range
Google Sheets — Read range
Section titled “Google Sheets — Read range”Type: googlesheets-read-range · Package: Google Sheets Activities v1.0.0 · Output: DataTable / List
Reads a specific range of cells. Same as Read sheet, but limited to a range in A1 notation — useful when you’re only interested in part of the sheet.
How it works
Section titled “How it works”Read the indicated range. With has-headers = true returns a DataTable; if not, a list of rows. Requires a Google Sheets — Open session.
Required parameters
Section titled “Required parameters”| Parameter | Editor | Description |
|---|---|---|
range | expression | Range in A1 notation: A1:E10, A:E, 1:100. |
Optional parameters
Section titled “Optional parameters”| Parameter | Editor | Description |
|---|---|---|
session | session | Google Sheets — Open session. Optional: within a body it is inherited. |
sheet | expression | Sheet name. By default, it activates it. |
has-headers | boolean | First row as headers → DataTable. By default false. |
Output
Section titled “Output”A DataTable (if has-headers) or a List of rows.
Example
Section titled “Example”Google Sheets — Read range session = = hoja range = "A1:D50" has-headers = true → output: datosRelated activities
Section titled “Related activities”- Read sheet — read the entire sheet.
- Read cell — read a cell.