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

POST

Clears one or more ranges of values from a spreadsheet. The caller must specify the spreadsheet ID and one or more DataFilters. Ranges matching any of the specified data filters will be cleared. 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

Body

Request Example

Shell

JavaScript

Java

Swift

curl --location --request POST 'https://sheets.googleapis.com//v4/spreadsheets//values:batchClearByDataFilter' \
--header 'Content-Type: application/json' \
--data-raw '{
    "dataFilters": [
        {
            "a1Range": "string",
            "developerMetadataLookup": {},
            "gridRange": {}
        }
    ]
}'

Response Example

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

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

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

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