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.a0AS3H6Nw6rTG3pFXv17ZLXkvuvtNl_DHHXbxe2yDRIB09Sq-BA7xPQj9V7OKAaAiHRZAsVqI0UD6026Q_3gklXjU-kam0kzFCe2adXI3lS...";
Spreadsheet = "1SDgvwigAytLRE0fDCwfhD8DAZzOpcNvNlOHXrQ-8XiY";
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 "1sn3t1HU4qCb03-Ht85AJW4r9Xt3yGlMAq-vRc3pdDlc" \
--cells "['B2','A3','B4']" \
--sheetname "Sheet2"
Result
{
"spreadsheetId": "1p_i-5lmOKdBEbi88O0SkXq2Q_gG0c4EY7N_wtWGKSCs",
"clearedRanges": [
"Sheet2!B2",
"Sheet2!A3",
"Sheet2!B4"
]
}