Question

How to find Excel column last second row

  • 30 April 2022
  • 1 reply
  • 15 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

Userlevel 4
Badge +8

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>

 

Reply