Hey Allan,

We don't currently expose a way to pull the images out of spreadsheets cells
for consumption like you're referring to.  You could probably get closer
using Google Apps Script, but even then you might not be able to use the
image in your own page.

http://code.google.com/googleapps/appsscript/

Thanks,
-Vic



On Mon, Dec 27, 2010 at 4:52 PM, thompa <[email protected]> wrote:

> Hi,
>
> I have a web page incorporating parts of a Google spreadsheet. I have been
> looking for a way to insert images into this web page from the Google
> Spreadsheet for some time!
>
> Two ways occurred to me but my coding is too poor to implement either idea
> - but I am working on it!
>
> Idea 1.
> Use a Google Script function to call insertImage(url,c,r) to insert an
> image into a Google Spreadsheet and insert the cell containing the image
> into a web page.
> Problem is that the 'insertImage' script command ties the corner of the
> image to the corner of the cell - but there is no other control seemingly on
> the size of the image. This could be pre-edited however.. but I haven't been
> able to make a Script work!
>
> Idea 2.
> Rather than incorporate the actual image in a Google Spreadsheet, include
> the web address of the image.
> Use a JSON feed and Javascript in the web page where the image is to be
> displayed to assign the contents of the cell holding the image web address
> to a variable and then code the variable into HTML using <img src...
>
> Because of the limitations of control of image attributes, I believe that
> Idea 2 has the best chance of success.... I am working on it - but research
> is very difficult for a newcomer to coding!
>
> Can anyone help!
>
> regards,
>
> Allan
>

Reply via email to