Google Sheet
app
GAS โฉ commands
a script that is bound to a Google Sheet is called a container-bound script.
ๅฐๆ classes (ๅฆ๏ผSheet, Range ...) ๆฒๆๅฐๅฑฌ็ prototypeโ๏ธ
๐ ๅ้ฑ๏ผ
prototype ใโใ้ ้ข
custom prototypes for Google Apps Script
Announcing the Apps Script connector for AppSheet: Automate workflows for Google Workspace
Ben Collins โฉ
Google Apps Script: A Beginnerโs Guide
Introduction To Google Apps Script (๐จ๐ปโ๐ ่ชฒ็จ )
API Tutorial For Beginners With Google Sheets & Apps Script
Sheet โฉ
getDataRange() - from A1 to the last cell with value.
getLastRow() - index of the last row that has content.
Range โฉ
Dialogs and Sidebars
Guides โฉ
Libraries - script project whose functions can be reused in other scripts.
Extending Google Sheet
V8 Runtime
David Weiss โฉ Apps Script โฉ
Spreadsheet Service
Maps Service
Sheet Playground
Google ้ฒ็ซฏ็ฏๆฌๅ
็ฎๅไธๆฏๆด class field๏ผไฝๅฏ็จ (static/instance) getter/setter ไปฃๆฟใ
Last updated 2 years ago
Was this helpful?