Chapter 18. Office Add-Ins and Google Add-Ons

This chapter will look at extending Office and Google Apps using HTML web apps that run on the client and orchestrate server-side activities.

Add-Ons

Add-ons came to Google Drive in 2014. In Chapter 10, we used add-ons in the context of writing container-bound apps associated with a particular doc, sheet, or form. Add-ons allow these kinds of extensions to be published in a store and installed by a user so that they are available for all of the user’s documents.

Coding add-ons is not much different from writing HtmlService custom menu extensions, although the process of publishing them is complicated.

Add-Ins

Excel users might be confused by the term add-ins, as it can also mean a companion workbook containing VBA code that can be executed by the main workbook, a COM add-in, or a VSTO add-in managed through the app’s add-in manager. A little like a library in Apps Script, an add-in is one method used to distribute useful extension code for general use.

The Microsoft Office add-in nowadays refers to a completely different capability. Formerly called Apps for Office, now the tool is referred to as Office Add-ins. Add-ins use the JavaScript API for Office to access the Office object model, and execute HTML/JavaScript apps in an iframe associated with the container document.

The Same...

At first glance, add-ons and add-ins seem very much alike:

  • Both run on the client and access data from the document on which they are operating. ...

Get Going GAS now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.