Search code examples
automationrpaautomationanywhere

Displaying the loop counter in Automation Anywhere

I have created a for loop for iterating excel files in automation anywhere. It contains 60000 rows. I want to print the counter value for each iteration of for loop. Message Box option is taking too much time. Is there any efficient way other than Message Box? My code is as follows..

Start Loop "Each row in an Excel dataset of session: Default"
    Message Box : "$Counter$"
End Loop
Solution

  • You can use the Log To File command as a light-weight logging system, preferably in a .txt file as it's faster. Just make sure you mark the checkbox stating 'append'.

    Sidenote: Have you considered using your Excel file into as data source? With an Excel file of this magnitude, it's a lot more efficient to use the Database command to iterate over your data. Here is a video showcasing how this is done.