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
  • 743 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+5
  • Most Valuable Pathfinder
  • 127 replies
  • 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+8
  • Navigator | Tier 3
  • 2445 replies
  • 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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings