Hi guys
For the image mentioned below i want to collect data from web,only the info of the companies which i have highlighted in red boxes(3 companies) with the headers. Then i want this data to be loaded and saved in a excel file . Which is the easiest way to do??
please help me out. Thank you!
@Dolvin_John is there any condition based on which you are extracting data? I yes, Please specify that. 
Hi!! i want to extract just the three data which i have boxed in red and load into a excel sheet. no other condition!
@Dolvin_John please provide the website link
@Dolvin_John what i’ve done is that for the first two items i have used data extraction and have limit the number of results to 3(Because we also are including the headers) and for the third data I’ve used get text and then stored it in same excel file using write cell…
Main.xaml (12.7 KB)
this is my workflow…
Hello @Dolvin_John,
I’d extract the complete table using data scraping and then filter it according to my need
Check out this workflow
Extract_Selective_Data.xaml (15.9 KB)
PS - You could also use Filter Data Table
thank you will check, as first two data are at top one below the other it was easy to extract, the thing i wanted to know is how we can extract the data in between other alternate companies specifically wanted into the excel is there any filter option that can extract the whole data and then select the specific company i want to show in excel
That is exactly what i’ve done @Dolvin_John
You could just add on to the filterString with desired expressions to filter it according to your need.
Cheers
thank you @Rishabh_Lakhera will check it out
Yoichi
Raja.G
mkt.scott4