Google Sheets — Used range
Google Sheets — Used range
Section titled “Google Sheets — Used range”Type: googlesheets-get-used-range · Package: Google Sheets Activities v1.0.0 · Output: Dictionary
Returns the dimensions of the data area of a sheet: how many rows and columns, where they end, and the range. Useful to know the size before processing or to build a dynamic range.
How it works
Section titled “How it works”Calculates the occupied area of the sheet and returns its metrics. Requires a Google Sheets — Open session.
Required parameters
Section titled “Required parameters”None.
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, the first. |
Output
Section titled “Output”Returns a Dictionary with: rows, columns, lastRow, lastColumn, range.
Example
Section titled “Example”Google Sheets — Used range session = = hoja sheet = "Datos" → output: dimLog message = = "Filas con datos: " + dim["rows"]Related activities
Section titled “Related activities”- Read range — read the area with data.
- Get sheet names — list the sheets.