February 2016
Beginner to intermediate
456 pages
9h 18m
English
Content preview from Going GAS
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
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. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.