Going GAS: From VBA to Google Apps Script
- Length: 456 pages
- Edition: 1
- Language: English
- Publisher: O'Reilly Media
- Publication Date: 2016-03-05
- ISBN-10: 1491940468
- ISBN-13: 9781491940464
- Sales Rank: #965618 (See Top 100 Books)
If you’re making or investigating the transition from Microsoft Office to Google Docs, or simply trying to get started with Google automation and APIs, this practical book covers each of the major services accessible from Google Apps Script, including add-ons and integration with external services.
With a particular emphasis on how to transition from Microsoft’s Visual Basic for Applications (VBA) to Apps Script, all the common VBA functions are rewritten in JavaScript with equivalence tables for how to do it in Apps Script.
This book provides a unique transitional library of VBA built-in functions, written in Apps Script but with the same names and arguments as VBA—that means you need to make only minimal changes to VBA code when “going GAS.”
- Learn how to go from VBA to Apps Script
- Get a side-by-side comparison of Apps Script services vs Microsoft add-ins
- Access and integrate with external data from Apps Script
Table of Contents
Chapter 1. Introduction
Chapter 2. Language Basics
Chapter 3. Translating VBA Functions
Chapter 4. Living with the Quotas
Chapter 5. The Properties Service
Chapter 6. The Spreadsheet Service
Chapter 7. The Document App
Chapter 8. Gmail, Calendar, and Contacts Apps
Chapter 9. Drive and DriveApp
Chapter 10. HTML Service
Chapter 11. Content Service
Chapter 12. Charts
Chapter 13. Sites
Chapter 14. Advanced Google Services
Chapter 15. Authentication and Security
Chapter 16. External APIs and Integration
Chapter 17. Execution API
Chapter 18. Office Add-Ins and Google Add-Ons
Appendix A. Further Resources
Donate to keep this site alive
How to download source code?
1. Go to: https://www.oreilly.com/
2. Search the book title: Going GAS: From VBA to Google Apps Script
, sometime you may not get the results, please search the main title
3. Click the book title in the search results
3. Publisher resources
section, click Download Example Code
.
1. Disable the AdBlock plugin. Otherwise, you may not get any links.
2. Solve the CAPTCHA.
3. Click download link.
4. Lead to download server to download.