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)
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:
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.
but is not working in my OutSystems
missing this extention
Hafiz Shaheed wrote:
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.