Menghapus nilai dari {i>spreadsheet<i}. Pemanggil harus menentukan ID spreadsheet dan rentang. Hanya nilai yang dihapus - semua properti sel lainnya (seperti pemformatan, validasi data, dll.) yang dipertahankan.
Permintaan HTTP
POST https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}:clear
Respons saat menghapus rentang nilai dalam spreadsheet.
Jika berhasil, isi respons memuat data dengan struktur berikut:
Representasi JSON
{"spreadsheetId": string,"clearedRange": string}
Kolom
spreadsheetId
string
Spreadsheet tempat pembaruan diterapkan.
clearedRange
string
Rentang (dalam notasi A1) yang dihapus. (Jika permintaan dibuat untuk rentang tak terbatas atau ranger yang lebih besar dari batas sheet, ini akan menjadi rentang sebenarnya yang dihapus, dibatasi ke batas sheet.)
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Informasi yang saya butuhkan tidak ada","missingTheInformationINeed","thumb-down"],["Terlalu rumit/langkahnya terlalu banyak","tooComplicatedTooManySteps","thumb-down"],["Sudah usang","outOfDate","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Masalah kode / contoh","samplesCodeIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 2024-09-05 UTC."],[[["Clears values from a specified spreadsheet and range while preserving formatting and other cell properties."],["Requires the spreadsheet ID and range in the request URL."],["Sends an empty request body and receives a response indicating the spreadsheet ID and cleared range."],["Needs authorization with specific OAuth scopes like `https://www.googleapis.com/auth/spreadsheets` or similar."]]],["To clear values in a spreadsheet, send a `POST` request to `https://sheets.googleapis.com/v4/spreadsheets/{spreadsheetId}/values/{range}:clear`. Include the `spreadsheetId` and `range` as path parameters. The request body must be empty. A successful response will contain the `spreadsheetId` and the `clearedRange` in the response body. This operation requires specific authorization scopes like `drive`, `drive.file`, or `spreadsheets`.\n"]]
