Scrapping images from HTML tables and save to excel sheet/datatable

[kl_kl]

How to scrape images from HTML tables and store them into datatable and further write it to an excel sheet where I can see the tables along with the images in respective cells. (I am trying to scrape the complete table “Countries and dependencies by area” along with images in this webpage List of countries and dependencies by area - Wikipedia)

[ppr (Peter Preuss)]

[HowTo] Data Scraping - Advanced Configuration - Text Field, Image Source, Url, CSS Classname, Hover text

This HowTo introduces on how Data scraping can be configured to retrieve also on non standard information from a web table. After indicating the different data columns with the wizard the extract data definition was post edited and changed to the relevant attributes e.g. value (Text field), src ( Image Source), class (CSS Class Name), tite (Hover Text), href (Url). Introduction Following web table is to use for data scraping and also the non text information should be retrieved. [grafik] We…

[kl_kl]

Thanks Peter , I wish to show the image in the datatable(or excel sheet) too not only the link of the image , like this one

[ppr (Peter Preuss)]

use link
download the pix temporarly
use activities to add it to Excel after writing the data

for downloading give a try on on HTTP Request activity or have a look here:

How to Count the Number of Product Images on Amazon

@Daun the invoke code part is retrieving the image data by url via a webrequest the invoke method is calling the save method from the retrieved image here you can configure the path to where the image should be saved: [grafik] open the parameters panel configure the path as by your requirements or reimplement it, by passing it by a variable When I checked the source, it seems that there are img sources readily available without hovering the thumbnail when I unfolded in the source, (thou…

[kl_kl]

Thanks Peter, solved my problem using your approach.
I had another idea(doubt) can I add the images as blob file in the datatable and finally write it to the excel sheet by rendering the blob to images[this will be much faster than the present solution, if possible]