Message Boards Message Boards

Referencing other Google Docs spreadsheet cells from EmbedCode functions

Arnoud Buzing, Wolfram Research
Posted 11 years ago

For the basics of embedding Wolfram Language functions in Google Docs spread sheets, please see: http://community.wolfram.com/groups/-/m/t/388578

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):

enter image description here

Now click on the cell B2 and type:

=wolframCloudCall(A2)

enter image description here

And then hit enter to get the answer:

enter image description here

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:

enter image description here
POSTED BY: Arnoud Buzing
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Tag limit exceeded
Note: Only the first five people you tag will receive an email notification; the other tagged names will appear as links to their profiles.
Reply Preview
Attachments
Remove
or Discard

Group Abstract Group Abstract