Google Sheets — Clear range
Google Sheets — Clear range
Section titled “Google Sheets — Clear range”Type: googlesheets-clear-range · Package: Google Sheets Activities v1.0.0
Deletes the content of a range of cells. Useful for cleaning up old data before writing new ones. Removes only the values, not the formatting (colors, borders).
How it works
Section titled “How it works”Empty the cells of the range indicated on the sheet. Requires a Google Sheets — Open session.
Required parameters
Section titled “Required parameters”| Parameter | Editor | Description |
|---|---|---|
range | expression | Range to clear in A1 notation: A1:Z100, A:Z (full columns). |
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”Clean and rewrite a results sheet:
Google Sheets — Clear range session = = hoja sheet = "Resultados" range = "A2:Z1000"Google Sheets — Write range session = = hoja sheet = "Resultados" range = "A2" values = = nuevosRelated activities
Section titled “Related activities”- Write sheet — escribir datos nuevos.
- Used range — know which area has data.