Delete Range
Last Updated: Mar 15, 2021
Last Updated: Mar 15, 2021
Use this function to delete the range of cells by shifting the rows or columns in a worksheet.
Delete Range (id_or_url, sheet_name_or_index , rng, shift_dimension, private_key, cient_email)
| Input Parameter Name | Description |
|---|---|
| id_or_url | ID or URL of Google Sheet |
| sheet_name_or_index | Name or index of worksheet |
| rng | Cell Range |
| shift_dimension | Dimension to shift the cells after deleting range of cells rows. Allowed inputs are
|
| private_key | Private key of the service account |
| client_email | Email ID of the service account |
| Return Value | Description |
|---|---|
| Output |
|
Delete Range (ABC123, Invoice, A1:B2, Row, —–BEGIN PRIVATE KEY—–\nABCD\n—–END PRIVATE KEY—–, name@project-id.iam.gserviceaccount.com)
To view all the Google Sheets functions, click here.