Cara Menjalankan Skrip di Google Spreadsheet

Disusun bersama Staf wikiHow

Artikel wikiHow ini mengajari Anda cara mengakses editor skrip Google di peramban internet desktop dan menjalankan kode dalam editor untuk tujuan pengujian.

Langkah

Unduh PDF

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3c\/Run-a-Script-on-Google-Sheets-Step-1.jpg\/v4-460px-Run-a-Script-on-Google-Sheets-Step-1.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3c\/Run-a-Script-on-Google-Sheets-Step-1.jpg\/v4-728px-Run-a-Script-on-Google-Sheets-Step-1.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Buka Google Spreadsheet di peramban internet Anda. Tikkan sheets.google.com di bilah alamat peramban Anda, dan tekan ↵ Enter atau ⏎ Return di kibor Anda.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/48\/Run-a-Script-on-Google-Sheets-Step-2.jpg\/v4-460px-Run-a-Script-on-Google-Sheets-Step-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/48\/Run-a-Script-on-Google-Sheets-Step-2.jpg\/v4-728px-Run-a-Script-on-Google-Sheets-Step-2.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Cari spreadsheet tempat Anda ingin menjalankan skrip dan buka.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/ba\/Run-a-Script-on-Google-Sheets-Step-3.jpg\/v4-460px-Run-a-Script-on-Google-Sheets-Step-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/ba\/Run-a-Script-on-Google-Sheets-Step-3.jpg\/v4-728px-Run-a-Script-on-Google-Sheets-Step-3.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Tombol ini ada di bilah tab di bawah nama file pada sudut kiri atas spreadsheet Anda. Ini akan membuka menu tarik-turun.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/01\/Run-a-Script-on-Google-Sheets-Step-4.jpg\/v4-460px-Run-a-Script-on-Google-Sheets-Step-4.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/01\/Run-a-Script-on-Google-Sheets-Step-4.jpg\/v4-728px-Run-a-Script-on-Google-Sheets-Step-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Ini akan membuka editor skrip berbasis peramban Google di tab baru.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/04\/Run-a-Script-on-Google-Sheets-Step-5.jpg\/v4-460px-Run-a-Script-on-Google-Sheets-Step-5.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/04\/Run-a-Script-on-Google-Sheets-Step-5.jpg\/v4-728px-Run-a-Script-on-Google-Sheets-Step-5.jpg","smallWidth":460,"smallHeight":343,"bigWidth":728,"bigHeight":543,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

5
Buat skrip Anda di editor skrip. Anda dapat menuliskan skrip Anda di sini atau menghapus semua yang ada di halaman tersebut dan menyalinkan kode dari papan klip Anda.
- Jika Anda mencari skrip yang bermanfaat, Google menawarkan beberapa saran dasar dalam panduan developer mereka.
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/52\/Run-a-Script-on-Google-Sheets-Step-6.jpg\/v4-460px-Run-a-Script-on-Google-Sheets-Step-6.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/52\/Run-a-Script-on-Google-Sheets-Step-6.jpg\/v4-728px-Run-a-Script-on-Google-Sheets-Step-6.jpg","smallWidth":460,"smallHeight":343,"bigWidth":728,"bigHeight":543,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

Klik judul "Untitled project" di sudut kiri atas halaman dan masukkan judul untuk proyek skrip baru Anda di bidang "Ganti Nama".
{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/84\/Run-a-Script-on-Google-Sheets-Step-7.jpg\/v4-460px-Run-a-Script-on-Google-Sheets-Step-7.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/84\/Run-a-Script-on-Google-Sheets-Step-7.jpg\/v4-728px-Run-a-Script-on-Google-Sheets-Step-7.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":542,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

7
Klik ikon

{"smallUrl":"https:\/\/www.wikihow.com\/images_en\/2\/22\/Android7play.png","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/22\/Android7play.png\/30px-Android7play.png","smallWidth":460,"smallHeight":460,"bigWidth":30,"bigHeight":30,"licensing":"<div class=\"mw-parser-output\"><\/div>"}

untuk menjalankan skrip. Tombol ini ada di bilah alat di bawah nama file dan bilah tab di sudut kanan atas jendela Anda. Ini akan menyimpan dan menjalankan kode di editor skrip.
- Jika Anda diminta untuk mengautorisasi pengujian skrip, klik tombol view Tinjau Izin , dan Izinkan pengujian skrip di pengaturan akun Anda.
Iklan

Masuk

Cara Menjalankan Skrip di Google Spreadsheet

Langkah

wikiHow Terkait

Tentang wikiHow ini

Apakah artikel ini membantu Anda?

Artikel Terkait

Ikuti kami

Bagikan

Explore Categories