How do I visit each URL in a excel column?

excel

#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


#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.


#4

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


How to Read a Data from CSV file and write in ONLINE application
Best approach to read many fields from excel and paste /enter on webpage
#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!