UpdateValuesResponse
JSON 表示法 |
{
"spreadsheetId": string,
"updatedRange": string,
"updatedRows": integer,
"updatedColumns": integer,
"updatedCells": integer,
"updatedData": {
object (ValueRange )
}
} |
欄位 |
spreadsheetId |
string
套用更新內容的試算表。
|
updatedRange |
string
套用更新的範圍 (以 A1 符號表示)。
|
updatedRows |
integer
列中至少一個儲存格完成更新的列數。
|
updatedColumns |
integer
資料欄中至少有一個儲存格已更新的資料欄數。
|
updatedCells |
integer
更新的儲存格數量。
|
updatedData |
object (ValueRange )
套用更新後的儲存格值。只有在要求的 includeValuesInResponse 欄位為 true 時,才會納入這個欄位。
|
除非另有註明,否則本頁面中的內容是採用創用 CC 姓名標示 4.0 授權,程式碼範例則為阿帕契 2.0 授權。詳情請參閱《Google Developers 網站政策》。Java 是 Oracle 和/或其關聯企業的註冊商標。
上次更新時間:2024-10-15 (世界標準時間)。
[null,null,["上次更新時間:2024-10-15 (世界標準時間)。"],[[["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"]]