Skip to main content
  • Home
  • Forums
  • Community Edition
  • I will loop through each rows in excel the active cell is not changed what can I do for this please could you help me on this.
I will loop through each rows in excel the active cell is not changed what can I do for this please could you help me on this.

@Prasanth A​  - you need to use Excel - Go to Cell to move to Next cell. Refer below AA Docs for step by step guide on it

 

https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/cloud-excel-action.html/p>

 

https://docs.automationanywhere.com/bundle/enterprise-v2019/page/enterprise-cloud/topics/aae-client/bot-creator/commands/cloud-excel-command.html/p>

 

Loop will do the iterations with Excel data set.

 

If this helps you please do Like & mark as "Best Answer" so it will be helpful for others as well. 

 

Best Regards,

Pradeep.

gards,

Pradeep.

Hi @Prasanth A​ ,

 

Along with the Loop, you have to either assign a Counter Variable to the Go To/Set Cell Action and increment it after each iteration, or use the Go To Cell: Active Cell: One Cell to the Left/Right etc.

 

imageOr

image 

Kind Regards,

Ashwin A.K

Reply


Terms & ConditionsCookie settings