Book description
Whether you’re moving from Microsoft Office to Google Docs or simply want to learn how to automate Docs with Google Apps Script, this practical guide shows you by example how to work with each of the major Apps Script services. The book introduces JavaScript basics for experienced developers unfamiliar with the language, and demonstrates ways to build real-world apps using all of the Apps Script services previously covered.
Publisher resources
Table of contents
- Preface
- 1. Introduction
- 2. Language Basics
- 3. Translating VBA Functions
- 4. Living with the Quotas
- 5. The Properties Service
-
6. The Spreadsheet Service
- Custom Formulas
- Container-Bound Versus Standalone Scripts
- Getting Started with the Spreadsheet Service
- The Range Class
- Inserting and Deleting Rows and Columns
- Opening Other Sheets
- Opening Other Workbooks
- Showing Messages
- Getting and Setting Properties
- Custom Formulas
- Adding Functions to Menus
- Tables
- 7. The Document App
- 8. Gmail, Calendar, and Contacts Apps
- 9. Drive and DriveApp
- 10. HTML Service
- 11. Content Service
- 12. Charts
- 13. Sites
- 14. Advanced Google Services
- 15. Authentication and Security
- 16. External APIs and Integration
-
17. Execution API
- What Is Incremental Migration?
- Migration Process
- The Execution API
- Inventory for Execution API
- Authentication and Access
- JSON
- SheetExec
- Example Workflow Migration from Office
- Moving a Workbook to Sheets
- Migrating Logic
- VBA Orchestration
- Final Migration Steps
- Testing JavaScript on the PC
- Execution API Potential
- 18. Office Add-Ins and Google Add-Ons
- Afterword
- A. Further Resources
- Index
Product information
- Title: Going GAS
- Author(s):
- Release date: February 2016
- Publisher(s): O'Reilly Media, Inc.
- ISBN: 9781491940464
You might also like
book
40 Algorithms Every Programmer Should Know
Learn algorithms for solving classic computer science problems with this concise guide covering everything from fundamental …
book
Software Engineering at Google
Today, software engineers need to know not only how to program effectively but also how to …
book
Head First Design Patterns, 2nd Edition
You know you don’t want to reinvent the wheel, so you look to design patterns—the lessons …
book
Fundamentals of Software Architecture
Salary surveys worldwide regularly place software architect in the top 10 best jobs, yet no real …