Skip to main content

Clear cells

Clears the value in cells

Function ClearCells(Val Token, Val Spreadsheet, Val CellsArray, Val Sheet = "") Export

ParameterCLI optionTypeRequiredDescription
Token--tokenStringToken
Spreadsheet--spreadsheetStringSpreadsheetID
CellsArray--cellsArray of StringArray of cells like A1 to be cleared
Sheet--sheetnameStringSheet 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);
    oint gsheets ClearCells \
--token "***" \
--spreadsheet "1NYD5B4YQnXCfmGMzXGh7GzA9Uk1tifgDK4A8682lufM" \
--cells "['B2','A3','B4']" \
--sheetname "Sheet2"
Result
{
"spreadsheetId": "1NYD5B4YQnXCfmGMzXGh7GzA9Uk1tifgDK4A8682lufM",
"clearedRanges": [
"Sheet2!B2",
"Sheet2!A3",
"Sheet2!B4"
]
}