Automation Anywhere Excel Loop

Question

Does anyone know of an easy way to start an excel loop in Automation Anywhere at a row other than 1? (or two by using contains header option). I would like to start a loop at row 5 but everything I have tried thus far does not work.

Thanks in advance.

Answer 1

To start from the fifth row you just need to navigate your starting cell to be the fifth row, this is quite easy, use the command - Go to Cell under Excel commands

Are you interested in learning RPA from the basics! Here's the right video for you on RPA provided by Intellipaat:

If you want to start from 5th row and 'A' column then before starting the excel loop:

These are the steps to do it :

Open spreadsheet

Select Go to Cell Command under excel commands

Select Specific Cell radio button

Provide the value of the Specific Cell as'A5'(which denotes 5th row and 'A' column)