Hi all, May I know the way how to go last row & last column of cell. I try with read range data table and assign variable of dt.rows.Count & dt.column.Count. I was finding the way to go the last row & column cell ID. If you have any idea please kindly help to share me. Thank You!

If DtData is my datatable, the last row and column item is at DtData.Rows(DtData.Rows.Count - 1)(DtData.Columns.Count - 1).

How to go last row & last column of cell

Natapong (Natapong Raojutitam) March 7, 2020, 3:58pm 3

You can use [Find LastRow] and [Find LastColumn] in BalaReva.EasyExcel.Activities to do that.

3 Likes

Topic		Replies	Views
Hello I would like to read the last cell of my exel Studio datatable , excel , uiautomation , robot , activities , studio , question , faq	4	1398	September 3, 2021
Find last row with data in Excel Studio studio , question , activities_panel	17	9739	July 8, 2022
Go to last cell in column which has data Help excel	3	1161	September 20, 2020
Delete last column and row in excel Help datatable , excel , activities , question	3	3692	January 31, 2020
How do I get the last value in Column A? Learn excel	17	5061	June 22, 2020