v1

latestOpenAPI 3.0.0Creative Commons Attribution 3.02026-07-1317262210.9 KB
spreadsheets

Clears one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or more ranges. Only values are cleared -- all other properties of the cell (such as formatting and data validation) are kept.

post/v4/spreadsheets/{spreadsheetId}/values:batchClear

Path parameters

spreadsheetIdstring required

The ID of the spreadsheet to update.

Request body

rangesstring[]

The ranges to clear, in A1 notation or R1C1 notation.

Response

Successful response