Google Sheets Programming With Google Apps Script (2015 Revision Complete)

Google Sheets Programming With Google Apps Script (2015 Revision Complete)

Michael Maguire
This is a sample of the book's content.Buy on Leanpub

Table of Contents

Google Sheets Programming With Google Apps Script (2015 Revision Complete)

  • Chapter 1: Introduction
    • 1.1 Google Sheets
    • 1.2 Google Apps Script (GAS)
    • 1.3 JavaScript or Google Apps Script?
    • 1.4 Summary Of Topics Covered
    • 1.5 Software Requirements For This Book
    • 1.6 Intended Readership
    • 1.7 Book Code Available On GitHub
    • 1.8 My Blog On Google Spreadsheet Programming
    • 1.8 Guideline On Using This Book
    • 1.9 2015 Update Notes
  • Chapter 2: Getting Started
    • 2.1 Introduction
    • 2.2 Google Apps Script Examples
    • 2.2 Executing Code – One Function At A Time
    • 2.3 Summary
  • Chapter 3: User-Defined Functions
    • 3.1 Introduction
    • 3.2 Built-in Versus User-Defined Functions
    • 3.3 Why Write User-Defined Functions
    • 3.4 What User-Defined Functions Cannot Do
    • 3.5 Introducing JavaScript Functions
    • 3.6 User-Defined Functions Versus JavaScript Functions
    • 3.7 Using JSDoc To Document Functions
    • 3.8 Checking Input And Throwing Errors
    • 3.9 Encapsulating A Complex Calculation
    • 3.10 Numeric Calculations
    • 3.11 Date Functions
    • 3.12 Text Functions
    • 3.13 Using JavaScript Built-In Object Methods
    • 3.14 Using A Function Callback
    • 3.15 Extracting Useful Information About The Spreadsheet
    • 3.16 Using Google Services
    • 3.18 Summary
  • Appendix A: Excel VBA And Google Apps Script Comparison
    • Introduction
    • Spreadsheets and Sheets
    • Ranges
Google Sheets Programming With Google Apps Script (2015 Revision Complete)/