Going GAS: From VBA to Google Apps Script

Передняя обложка
"O'Reilly Media, Inc.", 15 февр. 2016 г. - Всего страниц: 456
1 Отзыв
Google не подтверждает отзывы, однако проверяет данные и удаляет недостоверную информацию.

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
 

Отзывы - Написать отзыв

Не удалось найти ни одного отзыва.

Содержание

Chapter 1 Introduction
1
Chapter 2 Language Basics
17
Chapter 3 Translating VBA Functions
61
Chapter 4 Living with the Quotas
97
Chapter 5 The Properties Service
107
Chapter 6 The Spreadsheet Service
115
Chapter 7 The Document App
157
Chapter 8 Gmail Calendar and Contacts Apps
197
Chapter 13 Sites
299
Chapter 14 Advanced Google Services
301
Chapter 15 Authentication and Security
313
Chapter 16 External APIs and Integration
339
Chapter 17 Execution API
351
Chapter 18 Office AddIns and Google AddOns
379
Afterword
413
Appendix A Further Resources
415

Chapter 9 Drive and DriveApp
241
Chapter 10 HTML Service
253
Chapter 11 Content Service
273
Chapter 12 Charts
287
Index
419
About the Author
431
Авторские права

Другие издания - Просмотреть все

Часто встречающиеся слова и выражения

Об авторе (2016)

Bruce is a veteran IT practitioner with 30+ years as CIO, Chief Architect, and many other roles—mainly in large global enterprises such as Motorola and Lucent. With expertise in each of Google, Microsoft and Oracle technologies, his main interest is in integration.

For a number of years he has been running a range of popular sites and blogs providing advice and assistance on transition connectivity.

Bruce is a GDE (Google developer expert) specializing in Apps Script.

Библиографические данные