Google Sheets — Write range
Google Sheets — Write range
Section titled “Google Sheets — Write range”Type: googlesheets-write-range · Package: Google Sheets Activities v1.0.0
Writes values from a specific cell, overwriting what is there. Use it to place data in an exact position (filling an area of a template, writing headers in row 1).
How it works
Section titled “How it works”Write the values starting in cell/range range. Accepts a DataTable (or a DataRow for a single row); values only. Requires a Google Sheets — Open session.
Required parameters
Section titled “Required parameters”| Parameter | Editor | Description |
|---|---|---|
range | expression | Starting cell or range, e.g. A1, B3. |
values | expression | The DataTable to write (or a DataRow for a single row). |
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. |
Example
Section titled “Example”Google Sheets — Write range session = = hoja range = "A1" values = = arr(arr("Cliente", "Total")) // encabezadosGoogle Sheets — Write range session = = hoja range = "A2" values = = datosRelated activities
Section titled “Related activities”- Write sheet — write from A1.
- Write cell — write a single cell.
- Append rows — add to the end.