Skip to main content
Cadet | Tier 2
December 2, 2021
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
  • 891 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
    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
    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

    Blogs at TheCodingTheory - https://www.thecodingtheory.com