How do I visit each URL in a excel column?

Help
1

I have scraped some URL’s onto a excel file.

Now, how could I iterate through each excel coulmn, and visit each URL?

2

Instead of scrap you can use read range activity to get all the record
Use open browser activity to open the each url.using the for each row activity

1 Like
3

Read the url column. iterate it using for each row activity, inside for each activity place open browser and pass u r item in url field.

2 Likes
4

@Sami_Syed Check attached file i hope its useful OpenBrowserFromExcel.zip (12.5 KB)

2 Likes
5

Thank you so much!

6

I noticed you used the variable ‘dt’ for a data table. But I also noticed that a data table was never created?

Does a data table have to be created in order to use DataTable’s in the way you have in the attatched file?

7

My question is what’s the point of using excel application scope if right after we will be using a data table?

8

@Sami_Syed Data table is created in read range activity.

9

oh okay thanks!