Click on website link in each row of excel file and scan through webpage to scrape info

Hi all,

What would be the best series of activities to accomplish this task?

1 Like

Hi @Brennan_Montoni

  1. Read the excel file and store it in y (read range activity)

  2. Loop the datatable using for each row activity.

  3. Open the website using open browser activity or navigate to activity (if browser is already opened) pass row(“yourlinkcolumnname”).tostring

  4. Scrape the data from website using any of the following activities get text, get full text, anchor base,etc…

Thanks

1 Like