How to get the last Used Cell of Excel

Hello All -

I am trying to get the last used cell of excel (say for example if my excel has total data till 10th row, then i am trying to get “A10”) . How we can achieve this using Ui Path.

Thanks,
Sumit

@Kumar_Sumit_TKS
Welcome to our Uipath Community.:grimacing:
Use Read Column activity and you will get collection then get a count of that collection that will your last row value then append it with your column e.g. “A”+collection.Count.ToString

1 Like

Thanks it worked …

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.