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?