+1 vote
1 view
in RPA by (11.4k points)

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.

1 Answer

+1 vote
by (27.7k points)
edited by

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)

...