Going GAS: From VBA to Google Apps Script (Paperback)

Bruce Mcpherson

  • 出版商: O'Reilly
  • 出版日期: 2016-03-29
  • 定價: $1,225
  • 售價: 9.0$1,103
  • 語言: 英文
  • 頁數: 456
  • 裝訂: Paperback
  • ISBN: 1491940468
  • ISBN-13: 9781491940464
  • 相關分類: Excel
  • 立即出貨 (庫存 < 4)

買這商品的人也買了...

商品描述

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

商品描述(中文翻譯)

如果您正在從Microsoft Office轉換到Google Docs,或者只是想要開始使用Google自動化和API,這本實用書籍涵蓋了Google Apps Script中的每個主要服務,包括附加元件和與外部服務的整合。

本書特別強調如何從Microsoft的Visual Basic for Applications(VBA)轉換到Apps Script,將所有常見的VBA函數以JavaScript重新編寫,並提供了等價表,以指導如何在Apps Script中實現相同的功能。

本書提供了一個獨特的VBA內建函數過渡庫,這些函數以Apps Script編寫,但具有與VBA相同的名稱和參數,這意味著當您“轉換為GAS”時,只需要進行最小的VBA代碼更改。

本書內容包括:
- 學習如何從VBA轉換為Apps Script
- 對比Apps Script服務與Microsoft附加元件的差異
- 從Apps Script訪問和整合外部數據