Skip to main content
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.

  • December 2, 2021
  • 2 replies
  • 827 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

Pradeep Kintali
Most Valuable Pathfinder
Forum|alt.badge.img+6
  • Most Valuable Pathfinder
  • December 2, 2021

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


Ashwin A.K
Forum|alt.badge.img+10
  • Navigator | Tier 3
  • December 2, 2021

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