Take data from web page and put it in Excel form


#1

Hi,

I would like to take datas from a web page (ex: http://www.allocine.fr/film/fichefilm-239764/telecharger-vod/) and put it in an excel form (for this example I need to take all the prices and put them in an excel form).

I tried with data scraping, screen scraping but it doesn’t work I don’t know why.

How can I do it?

Thank you.


#2

data scraping should work for webpages.
Could you please attach the workflow.


#3

I just want the robot to open the browser, search title of a movie, take all the prices and transfer the data to an excel form but I don’t really know how it works it’s for my job they asked me this but it’s difficult to understand this software…


#4

Anyone?

I think it’s simple, I just want to scrape on a website and put these data in an excel table. But I don’t know how to do it…

Thanks in advance


#5

Hey @Ste

I am giving you an idea to take all prices from that page rest easily can manage i guess that is like open the browser,search the title of movie.

I have observed that the information on product pages consists multiple tables so you can easily scapre a whole table by using data scraping or directly by using “ExtractMetaData Text” .

So i have just counted the available tables on the page and based on that counter by using loop extracting all tables data by extracting table metadata and then removing unwanted column as per your need. extracted others columns because just thought in case you will need those as well.

For your reference find this attached sample and let me know :slight_smile: Scrap_Sample.xaml (11.9 KB)

Regards…!!
Aksh


#6

It doesn’t seems to work.
The thing is that I try to do something that is simple (in my mind ahah):

-I got an Excel file with title of movie
-The software take the title of the movie (write cell / read cell I understand it)
-Write the title in the website / Extract all the price and write all the prices in the excel file.

It’s like a loop but it’s difficult (because I don’t really understand this software, it’s new for me)

Thank you very much for your help :wink:


#7

Install available packages and let me know.


#8

Hello I want to do the opposite. I want to open like 10 account using the robot.
I want to use csv/excel to populate a web forms. How do I go about it? Kindly share an xaml file for me to follow.