Get links(Urls) from excel and open one by one

Help Studio
1

Hi,
Im new here :slightly_smiling_face:

Im trying to load urls from excell file, then open one by one with “open-browser”.

the next step is to scrape specific data and save it in other excel file.

I searched for an answer but i didnt get it work.
thanks for any help !

2

Hi

Welcome to uipath forum

Hope the below steps would help you resolve this

  1. Use a Excel application scope and pass the file path as input

  2. Inside the scope use a read range activity and get the output as dt

  3. Then use a For each row activity and pass dt as input and inside the loop use a Open browser activity where pass the input as CurrentRow(“yourcolumnname”).ToString
    Where mention the column name having url in it

  4. This will open the web page and next inside to this open browser use DATA SCRAPPING
    Have a view on this for using data scrapping and save the datatable as dt_extract

  1. That data scrapping will have the data you want

  2. Now use a Excel application scope and use write range activity and pass dt_extract as input and enable Add Headers property

Cheers @r.rooon

1 Like