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

POST

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.

Request

Path Params

Body Params application/json

Examples

Responses

🟢200Successful response

application/json

Body

Request Example

Shell

JavaScript

Java

Swift

curl --location --request POST 'https://sheets.googleapis.com//v4/spreadsheets//values:batchClear' \
--header 'Content-Type: application/json' \
--data-raw '{
    "ranges": [
        "string"
    ]
}'

Response Example

{
    "clearedRanges": [
        "string"
    ],
    "spreadsheetId": "string"
}

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

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

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