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
