Looping on URLs from Excel file using UiPath

+1 vote

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 ?

Jul 25, 2018 in RPA by wrecker
• 3,090 points
688 views

1 answer to this question.

0 votes

you have a 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.
answered Jul 25, 2018 by Atul
• 5,530 points

Related Questions In RPA

0 votes
1 answer

How to extract data from a website and save it to excel using UiPath?

Hi Piyush, if you want to extract ...READ MORE

answered Mar 8 in RPA by Anvi
• 9,910 points
1,420 views
0 votes
4 answers

Pivot table in excel using UIpath

You can use Create Pivot Table activity ...READ MORE

answered Feb 25 in RPA by Anvi
• 9,910 points
708 views
0 votes
1 answer

Pivot table in excel using UIpath

down vo I'd suggest you are going to ...READ MORE

answered May 28, 2018 in RPA by wrecker
• 3,090 points
637 views
0 votes
3 answers

How to find the sum of 2 columns of an excel and display it in a 3rd column using UIPATH?

1.  Excel Application Scope (Activity) : In ...READ MORE

answered Jun 9 in RPA by anonymous
• 140 points
2,007 views
0 votes
1 answer

Robot Manager in UiPath

the robot.exe file is located in: C:\Users\USER_ACCOUNT\AppData\Local\UiPath\app-17.1.6523\Ui-Robot.exe Hope it ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,090 points
300 views
0 votes
1 answer

Automation in Uipath

you can use the Database package for connecting  ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,090 points
252 views
0 votes
1 answer

UiPath vs Workfusion

in WorkFusion, you can create a script ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,090 points
891 views
0 votes
3 answers

Any open source tools for RPA ?

Yes, here is the Free RPA tool ...READ MORE

answered Oct 24, 2018 in RPA by Karthiksiddhu
• 240 points
156 views
0 votes
1 answer

How to delete some specific sheets from an existing excel file using vb.net code?

You can create a output of Excel ...READ MORE

answered Jul 27, 2018 in RPA by Atul
• 5,530 points
323 views
0 votes
1 answer

Changing a specific column of an excel sheet in UiPath

You can use a For each row ...READ MORE

answered Jun 21, 2018 in RPA by Atul
• 5,530 points
165 views