Referencing other Google Docs spreadsheet cells from EmbedCode functions

[arnoudb (Arnoud Buzing)]

For the basics of embedding Wolfram Language functions in Google Docs spread sheets, please see:

Using EmbedCode with Google Docs

This post is related to an earlier post on this topic , but it is written (and meant to be read) as a standalone post. Starting with Mathematica 10.0.1 (and also available in the Wolfram Programming Cloud) you can use "GoogleDocs" as an EmbedCode environment. For example you can do the following: EmbedCode[ APIFunction[ {"x"->"Number"}, #x^2& ], "GoogleDocs"] [qh4HJTM.png] Now open Google Docs (http://docs.google.com) and open a new spreadsheet (select "Sheets" from the top left menu): …

In this post we will show how to reference other spreadsheet cells with your embedded Wolfram Language cloud calls.
First create the following spreadsheet as shown (with two column labels and some numbers in the A column):

Now click on the cell B2 and type:

=wolframCloudCall(A2)

And then hit enter to get the answer:

Finally you can quickly do this for the whole B column by copying the cell B2 and pasting it to the selected range B3:B5: