Skip to main content
Cadet | Tier 2
June 2, 2022
Question

Hi, How to get the last row from the excel sheet using A360?

  • June 2, 2022
  • 2 replies
  • 405 views
Hi, How to get the last row from the excel sheet using A360?

    2 replies

    Automation Anywhere Team
    June 2, 2022

    You may use the 'Stimulate Keystrokes' action and press 'Ctrl+Down Arrow' to navigate to the last row of the worksheet

    Ashwin A.K
    Navigator | Tier 3
    June 6, 2022

    Hi @Pratiksha Pawar​ ,

     

    Maybe something like this is what you were looking for?

     

    image$CapturedTableData.DataTable:rowCount$-1 image$CapturedTableData[$int_rowCount$]{ColumnNameGoesHere}$

     

    Kind Regards,

    Ashwin A.K

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