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

POST

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

Path Params

Body Params application/json

Examples

Responses

🟢200Successful response

application/json

Bodyapplication/json

Request Example

Shell

JavaScript

Java

Swift

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

Response Example

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

Modified at 2023-08-15 07:09:28

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

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