Question

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.

  • 2 December 2021
  • 2 replies
  • 468 views

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.

2 replies

Badge +3

@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.

Userlevel 4
Badge +7

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