About the Book
All those who buy this version and those who have bought it already will get future updates and additions for free (2015 revision is complete).
Google Spreadsheets and Google Apps Scripts (GAS) are both evolving rapidly so I want to ensure that the material presented here remains up-to-date and continues to improve. Please email me details of any errors you find or with any suggestions you have for new material.
- Write user-defined spreadsheet functions.
- Manipulate the key Google API objects.
- Build user interfaces.
- Interact with other Google applications and services.
- Use a MySQL database running in the Cloud as a back-end data store.
Throughout there is an emphasis on practical applications.
It provides well documented code examples that can be cut-and-pasted and then modified to suit the reader's needs.
There is also an appendix for experienced Excel VBA users that shows common spreadsheet coding techniques in both VBA and Google Apps Script.
All the example code in this book is available for download as a single file at https://github.com/Rotifer/GoogleSpreadsheetProgramming_2015
Please send any feedback/queries/correction/requests for clarification to:
About the Author
I am a data manager. I used Excel VBA extensively in the past and wrote this book after learning how to program Google Spreadsheets with Google Apps Script.