UpdateValuesResponse
The response when updating a range of values in a spreadsheet.
| JSON representation |
{
"spreadsheetId": string,
"updatedRange": string,
"updatedRows": integer,
"updatedColumns": integer,
"updatedCells": integer,
"updatedData": {
object (ValueRange)
}
} |
| Fields |
spreadsheetId |
string
The spreadsheet the updates were applied to.
|
updatedRange |
string
The range (in A1 notation) that updates were applied to.
|
updatedRows |
integer
The number of rows where at least one cell in the row was updated.
|
updatedColumns |
integer
The number of columns where at least one cell in the column was updated.
|
updatedCells |
integer
The number of cells updated.
|
updatedData |
object (ValueRange)
The values of the cells after updates were applied. This is only included if the request's includeValuesInResponse field was true.
|
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-09-03 UTC.
[null,null,["Last updated 2024-09-03 UTC."],[[["This document describes the JSON response received when updating a range of values in a Google Sheet."],["The response includes details like the spreadsheet ID, updated range, the number of rows, columns, and cells affected, and optionally, the updated data itself."],["The `updatedData` field, containing the values after the update, is only present if `includeValuesInResponse` was set to `true` in the original request."]]],["The JSON response for a spreadsheet range update includes: `spreadsheetId` (the updated spreadsheet), `updatedRange` (the range modified), `updatedRows` (rows with at least one updated cell), `updatedColumns` (columns with at least one updated cell), and `updatedCells` (total updated cells). Optionally, if requested, `updatedData` (the new cell values) is provided. All the previous values are in string format, except the amount of updated Rows, columns and cells which are integers.\n"]]
