Clear cells
Clears the value in cells
Function ClearCells(Val Token, Val Spreadsheet, Val CellsArray, Val Sheet = "") Export
Parameter | CLI option | Type | Required | Description |
---|---|---|---|---|
Token | --token | String | ✔ | Token |
Spreadsheet | --spreadsheet | String | ✔ | SpreadsheetID |
CellsArray | --cells | Array of String | ✔ | Array of cells like A1 to be cleared |
Sheet | --sheetname | String | ✖ | Sheet name (first sheet by default) |
Returns: Map Of KeyAndValue - serialized JSON response from Google
1C:Enterprise/OneScript code example
Token = "ya29.a0AQQ_BDTgQbn9c5rXhPK3FCakms_7oKkdIWE1CCQFnSPftb2RxvloVqnYOcnsAKhXrD0Gq8Tz2Kgn5IBXG5E25uksZfvvTtXob-jFcuj_9LZYs9La4HrcFk766...";
Spreadsheet = "16uPAewX6jwjTdyVlE0O8adQngnoCMbUHQ5Ek36-IPaQ";
Sheet = "Sheet2";
CellsArray = New Array;
CellsArray.Add("B2");
CellsArray.Add("A3");
CellsArray.Add("B4");
Result = OPI_GoogleSheets.ClearCells(Token, Spreadsheet, CellsArray, Sheet);
- Bash
- CMD/Bat
oint gsheets ClearCells \
--token "***" \
--spreadsheet "1NYD5B4YQnXCfmGMzXGh7GzA9Uk1tifgDK4A8682lufM" \
--cells "['B2','A3','B4']" \
--sheetname "Sheet2"
oint gsheets ClearCells ^
--token "***" ^
--spreadsheet "1NYD5B4YQnXCfmGMzXGh7GzA9Uk1tifgDK4A8682lufM" ^
--cells "['B2','A3','B4']" ^
--sheetname "Sheet2"
Result
{
"spreadsheetId": "1NYD5B4YQnXCfmGMzXGh7GzA9Uk1tifgDK4A8682lufM",
"clearedRanges": [
"Sheet2!B2",
"Sheet2!A3",
"Sheet2!B4"
]
}