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
791 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

+2 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
• 11,690 points
2,515 views
0 votes
1 answer

how get the specific data from an excel and write in another excel file in uipath?

@Renuka, I agree with your approach. You ...READ MORE

answered 17 hours ago in RPA by Abha
• 19,420 points
52 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
• 11,690 points
790 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
736 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
339 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
284 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
946 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
197 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
409 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
198 views