Excel Loop through rows not working

[Randall.Hodges@bms.com]

I am unable to figure out how to loop through all the rows on my spreadsheet to perform my actions over and over until the end of the sheet.

I have one excel spreadsheet with two columns. I want to read both columns on my first itteration, and use the first cell for a search of a web application, some screen actions to initiate a download, then both first cell and second cell variables to name my download, kick off an FTP to move this file to another location, then repeat for the next row.

I can make this work once, but nothing causes it to cycle through the spreadsheet. I have tried with a "continue" and without.

Obviously I am missing someing.

Help!

[forumstaff]

Hello Randall.Hodges@bms.com,

We have prepared a sample task for you according to your requirement. Please download the attachment and save it in your computer.
You will have to save the "Sample.xls" in "C:/" and the "Sample_Excel.atmn" in "My Documents/Automation Anywhere/Automation Anywhere/My Tasks"

Please let us know in case you have any doubts.

Thanks & Regards

[Randall.Hodges@bms.com]

My issue was understanding how the process works. You must know then end of the range of cells when capturing the data, it does not iterate through until it gets to the last cell. Once I put the furthest cell in my range, it works fine.

Example: A1 through B2000 will execute 2000 times.

Thanks,
Randy Hodges

[forumstaff]

Hello Randall.Hodges@bms.com,

The attached task, according to your requirement, will perform the loop operation.

Please save the "Sample.xls" in "C:/" and the "loop sample.atmn" in "My Documents/Automation Anywhere/Automation Anywhere/My Tasks"

Thanks & Regards