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,110 points
1,045 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

+3 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
• 13,960 points
5,751 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 Aug 19 in RPA by Abha
• 27,180 points
359 views
0 votes
1 answer

How to read data from a excel, based on that data, check in the corresponding checkbox in browser appln? Uipath

Hi, to achieve this, you can perform ...READ MORE

answered Oct 10 in RPA by Abha
• 27,180 points
52 views
0 votes
1 answer

How to extract table and text from pdf file and load into Excel by using workbench commands in automation anywhere

Hey Dhruv, to extract table and text ...READ MORE

answered Oct 10 in RPA by Abha
• 27,180 points
108 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,110 points
457 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,110 points
364 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,110 points
1,105 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
267 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
685 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
232 views