/v4/spreadsheets/{spreadsheetId}/values/{range}:clear

POST

spreadsheets

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

Request Example

Shell

JavaScript

Java

Swift

curl --location --request POST 'https://sheets.googleapis.com//v4/spreadsheets//values/:clear' \
--header 'Content-Type: application/json' \
--data-raw '{}'

Response Example

{
    "clearedRange": "string",
    "spreadsheetId": "string"
}

Request

Path Params

spreadsheetId

string

required

The ID of the spreadsheet to update.

range

string

required

The A1 notation or R1C1 notation of the values to clear.

Body Params application/json

object {0}

Examples

Responses

🟢200Successful response

application/json

Body

The response when clearing a range of values in a spreadsheet.

clearedRange

string

optional

The range (in A1 notation) that was cleared. (If the request was for an unbounded range or a ranger larger than the bounds of the sheet, this will be the actual range that was cleared, bounded to the sheet's limits.)

spreadsheetId

string

optional

The spreadsheet the updates were applied to.

/v4/spreadsheets/{spreadsheetId}/values/{range}:append

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