in Education by
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. Select the correct answer from above options

1 Answer

0 votes
by
 
Best answer
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)

Related questions

0 votes
    I have created a for loop for iterating excel files in automation anywhere. It contains 60000 rows. I want to ... than Message Box? Select the correct answer from above options...
asked Feb 1, 2022 in Education by JackTerrance
0 votes
    I'm learning AAE for like a week and I have problem with for loop in excel file. I have prepared table with ... and how to fix it? Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I'm learning AAE for like a week and I have problem with for loop in excel file. I have prepared table with ... and how to fix it? Select the correct answer from above options...
asked Feb 5, 2022 in Education by JackTerrance
0 votes
    I have seen Microsoft Cognitive services such as text analytics and some other services. Here I have gone through ... much about it? Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I am writing a task in Automation Anywhere and would like it to break if a certain variable is set to "false" ... the code is executed? Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I am using AA for almost 6 months and I found that by default I am not able to see any lines/dotted lines/ ... to be set in properties? Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I need help with Automation Anywhere I have the following Drop-Down List and need to select an option. < option ... "0002" Thank you. Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I want to get a value from a particular location from list variable. Right now what I see is it only ... from a specified location? Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    How can I change the user input date format in Automation Anywhere without changing the system variable format? Example: ... 05/28/2018 Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    Hello I tried to use MWC function in AAE to pick the correct position form drop-down menu but I am receiving ... supposed to look like. Select the correct answer from above options...
asked Feb 8, 2022 in Education by JackTerrance
0 votes
    I am writing a task in Automation Anywhere and would like it to break if a certain variable is set to "false" ... the code is executed? Select the correct answer from above options...
asked Feb 5, 2022 in Education by JackTerrance
0 votes
    I am using AA for almost 6 months and I found that by default I am not able to see any lines/dotted lines/ ... to be set in properties? Select the correct answer from above options...
asked Feb 5, 2022 in Education by JackTerrance
0 votes
    I need help with Automation Anywhere I have the following Drop-Down List and need to select an option. < option ... "0002" Thank you. Select the correct answer from above options...
asked Feb 5, 2022 in Education by JackTerrance
0 votes
    I want to get a value from a particular location from list variable. Right now what I see is it only ... from a specified location? Select the correct answer from above options...
asked Feb 5, 2022 in Education by JackTerrance
0 votes
    How can I change the user input date format in Automation Anywhere without changing the system variable format? Example: ... 05/28/2018 Select the correct answer from above options...
asked Feb 5, 2022 in Education by JackTerrance
...