How can I display a URL as an image in an excel cell?




Can someone please explain to me how to turn a web link (URL) into an image.

Example image (URL is http://cache.lego.com/media/bricks/5/1/4667591.jpg)


What I am trying to do is make a parts list I have downloaded display the image rather than the above web link.

What I have in J2 to J1903 is:

http://cache.lego.com/media/bricks/5/1/4667591.jpg
http://cache.lego.com/media/bricks/5/1/4667521.jpg
...

What I would like to do is get excel to turn all these (10903 of them) into the pictures (cell size 81x81).

Can someone please explain step by step how I can do this?



microsoft-excel



in outsystem

Hi Hafiz,


You did link to the original posted question on Superuser (https://superuser.com/questions/940861/how-can-i-display-a-url-as-an-image-in-an-excel-cell).

Do those answers not suffice for your implementation? This question seems very unrelated to any OutSystems functions and/or forge components.



Dylan Heunis wrote:

Hi Hafiz,


You did link to the original posted question on Superuser (https://superuser.com/questions/940861/how-can-i-display-a-url-as-an-image-in-an-excel-cell).

Do those answers not suffice for your implementation? This question seems very unrelated to any OutSystems functions and/or forge components.

this the example what i said i get image link like this red circle

this is the example of my question i get like this link in my excel csv when i downlod

Alright.


I can point you to the excellent Forge component called AdvancedExcel https://www.outsystems.com/forge/component-overview/355/advanced-excel.

It has an action called Image_Insert that takes in binary data and inserts the image into the specified area. You can then generate the worksheet like that.

There is a demo for that component to teach you the fundamentals as well on how to build and generate the excel file, insert cells etc.

Dylan Heunis wrote:

Alright.


I can point you to the excellent Forge component called AdvancedExcel https://www.outsystems.com/forge/component-overview/355/advanced-excel.

It has an action called Image_Insert that takes in binary data and inserts the image into the specified area. You can then generate the worksheet like that.

There is a demo for that component to teach you the fundamentals as well on how to build and generate the excel file, insert cells etc.


but is not working in my OutSystems


missing this extention 

Hafiz Shaheed wrote:

missing this extention 


Hi Hafiz,

Which module's dependencies are you trying to refresh there?If it is the AdvancedExcel Demo you are trying to refresh, please first go to the forge and download the AdvancedExcel extension and install it into your environment. Then refresh the demo app again and it should work.