Method: spreadsheets.values.append
Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Menambahkan nilai ke spreadsheet. Rentang input digunakan untuk menelusuri data yang ada dan menemukan "tabel" dalam rentang tersebut. Nilai akan ditambahkan ke baris berikutnya dari tabel, dimulai dengan kolom pertama tabel. Lihat panduan dan kode contoh untuk mengetahui detail spesifik tentang cara tabel terdeteksi dan data ditambahkan.
Pemanggil harus menentukan ID spreadsheet, rentang, dan valueInputOption. valueInputOption hanya mengontrol cara data input akan ditambahkan ke sheet (menurut kolom atau baris), dan tidak memengaruhi sel tempat data mulai ditulis.
Permintaan HTTP
POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}:append
URL menggunakan sintaksis gRPC Transcoding.
Parameter jalur
| Parameter |
spreadsheetId |
string
ID spreadsheet yang akan diperbarui.
|
range |
string
Notasi A1 dari rentang untuk menelusuri tabel data yang logis. Nilai ditambahkan setelah baris terakhir tabel.
|
Parameter kueri
| Parameter |
valueInputOption |
enum (ValueInputOption)
Cara data input harus ditafsirkan.
|
insertDataOption |
enum (InsertDataOption)
Cara data input harus disisipkan.
|
includeValuesInResponse |
boolean
Menentukan apakah respons pembaruan harus menyertakan nilai sel yang ditambahkan. Secara default, respons tidak menyertakan nilai yang diperbarui.
|
responseValueRenderOption |
enum (ValueRenderOption)
Menentukan cara nilai dalam respons harus dirender. Opsi render default-nya adalah FORMATTED_VALUE.
|
responseDateTimeRenderOption |
enum (DateTimeRenderOption)
Menentukan cara tanggal, waktu, dan durasi dalam respons harus dirender. Nilai ini akan diabaikan jika responseValueRenderOption adalah FORMATTED_VALUE. Opsi rendering dateTime default-nya adalah SERIAL_NUMBER.
|
Isi permintaan
Isi permintaan memuat instance ValueRange.
Isi respons
Respons saat memperbarui rentang nilai di spreadsheet.
Jika berhasil, isi respons memuat data dengan struktur berikut:
| Representasi JSON |
{
"spreadsheetId": string,
"tableRange": string,
"updates": {
object (UpdateValuesResponse)
}
} |
| Kolom |
spreadsheetId |
string
Spreadsheet tempat pembaruan diterapkan.
|
tableRange |
string
Rentang (dalam notasi A1) tabel tempat nilai ditambahkan (sebelum nilai ditambahkan). Kosong jika tidak ditemukan tabel.
|
updates |
object (UpdateValuesResponse)
Informasi tentang update yang diterapkan.
|
Cakupan otorisasi
Memerlukan salah satu cakupan OAuth berikut:
https://www.googleapis.com/auth/drivehttps://www.googleapis.com/auth/drive.filehttps://www.googleapis.com/auth/spreadsheets
Untuk mengetahui informasi selengkapnya, lihat Panduan otorisasi.
InsertDataOption
Menentukan cara data yang ada diubah saat data baru dimasukkan.
| Enum |
OVERWRITE |
Data baru akan menimpa data yang ada di area tempat data tersebut ditulis. (Catatan: menambahkan data ke bagian akhir sheet akan tetap menyisipkan baris atau kolom baru sehingga data dapat ditulis.) |
INSERT_ROWS |
Baris disisipkan untuk data baru. |
Kecuali dinyatakan lain, konten di halaman ini dilisensikan berdasarkan Lisensi Creative Commons Attribution 4.0, sedangkan contoh kode dilisensikan berdasarkan Lisensi Apache 2.0. Untuk mengetahui informasi selengkapnya, lihat Kebijakan Situs Google Developers. Java adalah merek dagang terdaftar dari Oracle dan/atau afiliasinya.
Terakhir diperbarui pada 2025-03-22 UTC.
[null,null,["Terakhir diperbarui pada 2025-03-22 UTC."],[],[],null,["# Method: spreadsheets.values.append\n\n- [HTTP request](#body.HTTP_TEMPLATE)\n- [Path parameters](#body.PATH_PARAMETERS)\n- [Query parameters](#body.QUERY_PARAMETERS)\n- [Request body](#body.request_body)\n- [Response body](#body.response_body)\n - [JSON representation](#body.AppendValuesResponse.SCHEMA_REPRESENTATION)\n- [Authorization scopes](#body.aspect)\n- [InsertDataOption](#InsertDataOption)\n- [Try it!](#try-it)\n\nAppends values to a spreadsheet. The input range is used to search for existing data and find a \"table\" within that range. Values will be appended to the next row of the table, starting with the first column of the table. See the [guide](https://developers.google.com/workspace/sheets/api/guides/values#appending_values) and [sample code](https://developers.google.com/workspace/sheets/api/samples/writing#append_values) for specific details of how tables are detected and data is appended.\n\nThe caller must specify the spreadsheet ID, range, and a [valueInputOption](/workspace/sheets/api/reference/rest/v4/ValueInputOption). The `valueInputOption` only controls how the input data will be added to the sheet (column-wise or row-wise), it does not influence what cell the data starts being written to.\n\n### HTTP request\n\n`POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}:append`\n\nThe URL uses [gRPC Transcoding](https://google.aip.dev/127) syntax.\n\n### Path parameters\n\n| Parameters ||\n|-----------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|\n| `spreadsheetId` | `string` The ID of the spreadsheet to update. |\n| `range` | `string` The [A1 notation](https://developers.google.com/workspace/sheets/api/guides/concepts#cell) of a range to search for a logical table of data. Values are appended after the last row of the table. |\n\n### Query parameters\n\n| Parameters ||\n|--------------------------------|------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|\n| `valueInputOption` | `enum (`[ValueInputOption](/workspace/sheets/api/reference/rest/v4/ValueInputOption)`)` How the input data should be interpreted. |\n| `insertDataOption` | `enum (`[InsertDataOption](/workspace/sheets/api/reference/rest/v4/spreadsheets.values/append#InsertDataOption)`)` How the input data should be inserted. |\n| `includeValuesInResponse` | `boolean` Determines if the update response should include the values of the cells that were appended. By default, responses do not include the updated values. |\n| `responseValueRenderOption` | `enum (`[ValueRenderOption](/workspace/sheets/api/reference/rest/v4/ValueRenderOption)`)` Determines how values in the response should be rendered. The default render option is [FORMATTED_VALUE](/workspace/sheets/api/reference/rest/v4/ValueRenderOption). |\n| `responseDateTimeRenderOption` | `enum (`[DateTimeRenderOption](/workspace/sheets/api/reference/rest/v4/DateTimeRenderOption)`)` Determines how dates, times, and durations in the response should be rendered. This is ignored if [responseValueRenderOption](/workspace/sheets/api/reference/rest/v4/spreadsheets.values/append#body.QUERY_PARAMETERS.response_value_render_option) is [FORMATTED_VALUE](/workspace/sheets/api/reference/rest/v4/ValueRenderOption). The default dateTime render option is [SERIAL_NUMBER](/workspace/sheets/api/reference/rest/v4/DateTimeRenderOption). |\n\n### Request body\n\nThe request body contains an instance of [ValueRange](/workspace/sheets/api/reference/rest/v4/spreadsheets.values#ValueRange).\n\n### Response body\n\nThe response when updating a range of values in a spreadsheet.\n\nIf successful, the response body contains data with the following structure:\n\n| JSON representation |\n|-------------------------------------------------------------------------------------------------------------------------------------------------|\n| ``` { \"spreadsheetId\": string, \"tableRange\": string, \"updates\": { object (/workspace/sheets/api/reference/rest/v4/UpdateValuesResponse) } } ``` |\n\n| Fields ||\n|-----------------|----------------------------------------------------------------------------------------------------------------------------------------------------|\n| `spreadsheetId` | `string` The spreadsheet the updates were applied to. |\n| `tableRange` | `string` The range (in A1 notation) of the table that values are being appended to (before the values were appended). Empty if no table was found. |\n| `updates` | `object (`[UpdateValuesResponse](/workspace/sheets/api/reference/rest/v4/UpdateValuesResponse)`)` Information about the updates that were applied. |\n\n### Authorization scopes\n\nRequires one of the following OAuth scopes:\n\n- `https://www.googleapis.com/auth/drive`\n- `https://www.googleapis.com/auth/drive.file`\n- `https://www.googleapis.com/auth/spreadsheets`\n\nFor more information, see the [Authorization guide](/workspace/guides/configure-oauth-consent).\n\nInsertDataOption\n----------------\n\nDetermines how existing data is changed when new data is input.\n\n| Enums ||\n|---------------|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|\n| `OVERWRITE` | The new data overwrites existing data in the areas it is written. (Note: adding data to the end of the sheet will still insert new rows or columns so the data can be written.) |\n| `INSERT_ROWS` | Rows are inserted for the new data. |"]]
