Method: spreadsheets.sheets.copyTo
Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Menyalin satu sheet dari spreadsheet ke spreadsheet lain. Menampilkan properti sheet yang baru dibuat.
Permintaan HTTP
POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyTo
URL menggunakan sintaksis gRPC Transcoding.
Parameter jalur
| Parameter |
spreadsheetId |
string
ID spreadsheet yang berisi sheet yang akan disalin.
|
sheetId |
integer
ID sheet yang akan disalin.
|
Isi permintaan
Isi permintaan memuat data dengan struktur berikut:
| Representasi JSON |
{
"destinationSpreadsheetId": string
} |
| Kolom |
destinationSpreadsheetId |
string
ID spreadsheet tempat sheet akan disalin.
|
Isi respons
Jika berhasil, isi respons memuat instance SheetProperties.
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.
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-05-05 UTC.
[null,null,["Terakhir diperbarui pada 2025-05-05 UTC."],[],[],null,["# Method: spreadsheets.sheets.copyTo\n\n- [HTTP request](#body.HTTP_TEMPLATE)\n- [Path parameters](#body.PATH_PARAMETERS)\n- [Request body](#body.request_body)\n - [JSON representation](#body.request_body.SCHEMA_REPRESENTATION)\n- [Response body](#body.response_body)\n- [Authorization scopes](#body.aspect)\n- [Try it!](#try-it)\n\nCopies a single sheet from a spreadsheet to another spreadsheet. Returns the properties of the newly created sheet.\n\n### HTTP request\n\n`POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/sheets/{sheetId}:copyTo`\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 containing the sheet to copy. |\n| `sheetId` | `integer` The ID of the sheet to copy. |\n\n### Request body\n\nThe request body contains data with the following structure:\n\n| JSON representation |\n|------------------------------------------------|\n| ``` { \"destinationSpreadsheetId\": string } ``` |\n\n| Fields ||\n|----------------------------|----------------------------------------------------------|\n| `destinationSpreadsheetId` | `string` The ID of the spreadsheet to copy the sheet to. |\n\n### Response body\n\nIf successful, the response body contains an instance of [SheetProperties](/workspace/sheets/api/reference/rest/v4/spreadsheets/sheets#SheetProperties).\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)."]]
