Skip to main content
Cadet | Tier 2
April 30, 2022
Question

How to find Excel column last second row

  • April 30, 2022
  • 1 reply
  • 201 views
Hi, I have Excel with five columns data with N number of records but we need to fetch each column last second row record we needs to fetch. Please do let me know how to find this.please suggest me thanks in advance.

    1 reply

    Automation Anywhere Team
    June 25, 2022

    Hello @Naveen Kumar​ 

     

    Thanks for writing us at the AA forum.

     

    You can check the index values of the column in excel and then retrieve the value based on the column's index.

     

    You can leverage the available bots in the botstore to get the use case function

     

    https://botstore.automationanywhere.com/search?s=excelamp;post_type=product

     

    For assistance through our Support Engineers, please reach us via Support case

     

    https://apeople.automationanywhere.com/s/article/How-to-create-a-support-case-in-service-cloud/p>

     

    You can also check our Live Chat support option, for quick assistance from our engineers

     

    https://apeople.automationanywhere.com/s/article/Live-Chat-Support-FAQs/p>

     

    You can also search for available documentation in

     

    https://docs.automationanywhere.com//p>

     

    For more details, you are welcome to leverage our open source portal where multiple use case is available

     

    https://botstore.automationanywhere.com//p>