Inserting Images in Google Spreadsheet.
I was working on collecting icons for various hosts to for display.
Most of the icon extraction part was automated. Since, the icons
reflected directly in the UI, a manual round(minimum 1 round) of intervention had to
take place.
The format was something like this
So far so good. I looked at the spreadsheet shared with me and each time I had to
click on the icon link, go to host and then cross check if this was the correct
mapping.
Hmm! This was tiring.
I wondered if somehow the images directly relfected in the spreadsheet cells.
A quick search revealed that Googledocs already have the provision to insert images
in the cells in various ways(URLs,local machine, picasa web albums etc).
for the image url, just include the formula =Image("url")
And everytime I update a link in the first cell, I see the result in the third cell.
A simple feature saved a lot of my time.
More about it here
http://support.google.com/
I was working on collecting icons for various hosts to for display.
Most of the icon extraction part was automated. Since, the icons
reflected directly in the UI, a manual round(minimum 1 round) of intervention had to
take place.
The format was something like this
So far so good. I looked at the spreadsheet shared with me and each time I had to
click on the icon link, go to host and then cross check if this was the correct
mapping.
Hmm! This was tiring.
I wondered if somehow the images directly relfected in the spreadsheet cells.
A quick search revealed that Googledocs already have the provision to insert images
in the cells in various ways(URLs,local machine, picasa web albums etc).
for the image url, just include the formula =Image("url")
And everytime I update a link in the first cell, I see the result in the third cell.
A simple feature saved a lot of my time.
More about it here
http://support.google.com/
