Going GAS
From VBA to Google Apps Script
Paperback Engels 2016 1e druk 9781491940464Samenvatting
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.
Office still supports VBA, but it’s not likely to do so for much longer. If you’re a VBA or .NET developer, you’ll learn how to port existing VBA code and structure to their JavaScript-based Apps Script equivalents with minimal effort. Author Bruce Mcpherson 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.
- Use App Script’s equivalent of Excel’s object model
- Target the most commonly used parts of Microsoft Word
- Automate processes in Gmail, Calendar, and Contacts
- Access the local client filesystem with Google Drive
- Build and run applications in a browser
- Store persistent data conveniently
- Render HTML content in response to HTTP requests
- Automate the maintenance and creation of pages and content
- Interact with a REST service or NoSQL database
- Access Apps Script capabilities from other platforms
Specificaties
Lezersrecensies
Inhoudsopgave
1. Introduction
-What Is VBA?
-What Is JavaScript?
-What Is Apps Script?
-What Are Google Add-Ons?
-What Are Google Forms?
-What Are Microsoft Add-Ins?
-Comparison
2. Language Basics
-Style
-Operators
-Variables
-Functions
-Layout
-Scope
-Objects
-Classes
-Namespaces
-The IDE
-Libraries
3. Translating VBA Functions
-Conventions
-Library and Namespace
-JSDOC
-VBA Built-Ins Translated to JavaScript
-Handling Errors
-VBA Built-In Objects
4. Living with the Quotas
-The Quotas
-Throttling
-Avoiding Service Calls
5. The Properties Service
-APIs Versus Built-In Services
-Getting Started with Properties Service
-Uses and Types of Property Stores
-Selecting a Property Store
-The Registry Versus the Property Store
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
-Opening Documents
-Traversing the Document
-Ranges
-Named Ranges
-Position
-Bookmarks
-Editing Text in Elements
-Adding Elements
-Inserting Elements
-Tables
-List Items
-Images
-Docs Automation Example
-Attributes
8. Gmail, Calendar, and Contacts Apps
-Email Automation Exercise
-Threads
-Messages
-Recipients
-Labels
-Calendar
-Contacts
-Setting Up the Example
-Triggers
9. Drive and DriveApp
-Microsoft OneDrive
-Reading and Writing Files
10. HTML Service
-Why Client Execution?
-HTML Service Varieties
-jQuery
-Event Handling
-Templates
-Controlling Apps Script from the Client
-Dialog HtmlService
-HtmlService Web Apps
-VBA User Form
11. Content Service
-The Content Service
-Where to Use the Content Service
-Types of Content
-Example
-JSONP
-XML
-Publishing
-Delegation from VBA
12. Charts
-Chart Data
-VBA Charts
-Sheets Charts
-EmbeddedChartBuilder
-Visualization API
-Other Chart Formats
13. Sites
-Apps Script
-Gadgets
-Code Lockdown
-Advertising
-VBA
-The Future of Sites
14. Advanced Google Services
-What Are Advanced Google Services?
-Advanced Services Versus Google APIs
-Developers Console
-Fusion Tables Example
-Scripts Structure
-Currently Available Advanced Services
15. Authentication and Security
-OAuth 2.0
-Scopes
-Listing Authorized Apps
-Revoking Access
-ScriptApp
-Service Accounts
-Libraries
-OAuth 2.0 Example
-Accessing Other Oauth 2.0 Services
-OAuth 2.0 with VBA
-Other Kinds of Authentication
-JWT (JSON Web Tokens)
-Firebase Authentication
-Standardized OAuth 2.0 Process
16. External APIs and Integration
-REST API
-Databases
-Firebase
-Databases and Apps Script
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
-Add-Ons
-Add-Ins
-The Same...
-...But Different
-Add-On Example
-Apps Script Add-On
-Testing an Add-On
-Office Add-In
-Testing the Add-In
-Result Comparison
-Further Exercises
Appendix A: Further Resources
Index
Rubrieken
- advisering
- algemeen management
- coaching en trainen
- communicatie en media
- economie
- financieel management
- inkoop en logistiek
- internet en social media
- it-management / ict
- juridisch
- leiderschap
- marketing
- mens en maatschappij
- non-profit
- ondernemen
- organisatiekunde
- personal finance
- personeelsmanagement
- persoonlijke effectiviteit
- projectmanagement
- psychologie
- reclame en verkoop
- strategisch management
- verandermanagement
- werk en loopbaan
