Get Last Row and Column of the Excel


Read range in excel application scope is getting hanged if the excel has lot of empty rows.

Please let me know how to get range of the excel(last row & last column) without read range or without data table.

Hello @balarajesh.p ,

Please refer the below video, I think this answers your query.


Thanks for sharing. Is there any way to get them without using invoke code as this is not permitted to use for the client which i am working.