Looping through an Excel file in Automation Anywhere

0 votes

I have a loop issue in the Excel file. I've prepared a table with Vendor, Material and order Quantity as shown below:

Vendor Material Quantity
25000 1545454 100
64003 7854786 1024
25000 5896471 250
25000 3336661 900
64003 7854786 2048
25000 3336691 900

I wanted to validate the table if there is any redundancy in the material and vendor column. I have created 6 variables, 2 variables for each of the three columns. I have named them v1,m1,q1 and v2,m2,q2. I have also used 2 iterators- iterator1 and iterator2 whose value I am incrementing in two loops.

Here is the screenshot of what the code looks like:

This code is giving me an error, the loop runs for an infinite number of times. Can someone help me fix this?



Jul 9 in RPA by DareDev
• 6,810 points

1 answer to this question.

0 votes


There are a few corrections to be made in the code:

1.) Use another iterator- iterator3 and set its value to 5

2.) Use your variable operations command outside the inner loop

3.) Loop through the file using iterator3 and decrement this value

4.) Use your variable operation command between if and end loop

For more details refer to the code below

I hope this helped..!!

answered Jul 9 by Iffath
• 560 points
Hi Iffath, thanks for sharing the answer. I was also facing the same problem, it really helped.

Related Questions In RPA

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
• 22,960 points
0 votes
2 answers

change a specific column of an excel sheet in UiPath

1. First of all , you need ...READ MORE

answered May 16 in RPA by Venkat
• 320 points
0 votes
1 answer

How to assign a data in a variable in to excel file?

System -> File -> Workbook -> Append ...READ MORE

answered May 22, 2018 in RPA by wrecker
• 3,110 points
0 votes
4 answers

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

These are the steps to add two ...READ MORE

answered Aug 2 in RPA by Shivi Singhal
0 votes
1 answer

What is the recommended way to open an application as part of a task in Automation Anywhere?

The recommended methods for opening an application ...READ MORE

answered Apr 1 in RPA by Iffath
• 1,180 points
0 votes
1 answer

UiPath - Citirx Automation

best way to do that is to ...READ MORE

answered Apr 13, 2018 in RPA by wrecker
• 3,110 points
0 votes
1 answer

UiPath - Web Scraping

Multiple solutions are listed below: Check your Selector Use ...READ MORE

answered Apr 13, 2018 in RPA by wrecker
• 3,110 points
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
+1 vote
1 answer

How do i share a session in Automation Anywhere?

You can create a hierarchy of TaskBot ...READ MORE

answered May 14 in RPA by Iffath
• 560 points
0 votes
1 answer

Can I get all the file names in a folder to perform some operation on

Yes, you can use the "Loop for ...READ MORE

answered May 10 in RPA by Iffath
• 560 points