+1 vote
1 view
in RPA by (11.8k points)

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.

anyone can suggest some easy way to do it?

1 Answer

+1 vote
by (27.7k points)
edited by

 I didn’t really get what you were trying to do please elaborate but as per my understanding of your query you’re trying to URL in each row inside a column, here is the solution for this

Are you interested in learning UIpath from the basics! Here's the right video for you on UIpath provided by Intellipaat:

Take one excel application scope and give it the path of the excel file you’re trying to read and create a ‘data table’ object.

Next, use ‘for each row’ activity and give your data table object

Then within this loop use ‘assign’ activity and set the url=row.Item(“urlColumnname”).ToString()

After this is done you need to navigate to the website to do that use ‘Navigate to’ activity to visit each url.

Related questions

Welcome to Intellipaat Community. Get your technical queries answered by top developers !