Looping on URLs from Excel file using UiPath

Question

I have tried several ways but somehow they dont look clean;

1. I have a URL file in Excel format (400+ urls in a column)
2. I want UiPath to read from that file and browse these URLs one by one

I tried with making "Navigate to" read from a variable that reads from Excel but it just gets messy and does not work.

Any help ?

Answer 1

you have an Excel file with a column containing the URLs and you want to visit each one - in this case:

1. Take one excel application scope activity Give the path of your excel file...Create one DataTable object.
2. Use a For Each Row activity, providing your DataTable object.
3. Within the loop, use an Assign activity, and set url=row.Item("urlColumnname").ToString()
4. Use an Navigate To activiy to visit each URL.

Gain expertise in robot process automation (RPA) tools and concepts by obtaining RPA with UiPath certifications.