Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://developers.google.com/workspace/sheets/api/reference/rest/v4/spreadsheets.values/batchClear below:

Method: spreadsheets.values.batchClear | Google Sheets

Stay organized with collections Save and categorize content based on your preferences.

• HTTP request
• Path parameters
• Request body
  • JSON representation
• Response body
  • JSON representation
• Authorization scopes
• Try it!

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 https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values:batchClear

The URL uses gRPC Transcoding syntax.

string

The ID of the spreadsheet to update.

The request body contains data with the following structure:

{
  "ranges": [
    string
  ]
}

string

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

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

If successful, the response body contains data with the following structure:

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

string

The spreadsheet the updates were applied to.

string

The ranges that were cleared, in A1 notation. If the requests are for an unbounded range or a ranger larger than the bounds of the sheet, this is the actual ranges that were cleared, bounded to the sheet's limits.

Requires one of the following OAuth scopes:

• https://www.googleapis.com/auth/drive
• https://www.googleapis.com/auth/drive.file
• https://www.googleapis.com/auth/spreadsheets

For more information, see the Authorization guide.

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4