How to find highest row of particular column?

Topics: Developer Forum, User Forum
Jul 25, 2013 at 8:25 PM
Hi,

How can I find the last row of particular column?


i know that getHighestRow() will give you the highest row of the sheet.


Is there a way to find highest row for specified column??


Thank you!!
Jul 25, 2013 at 10:27 PM
Dhee,

If you get a column as reference, it contains basically all rows from worksheet right?

So, if your column contains all rows why is not good the result from getHighestRow method?

Regard,

Andrei Kun
Jul 25, 2013 at 10:42 PM
Hello Andrei,

Thanks for you response.

If you look at this image below:

Image

I would like to get row 5 as my response, since it is the last entry under column A and would like to ignore rows 6 and 7

When I use getHighestRow method I would get row 7 as highest row.

Hope I'm clear this time.


Regards,

Dheeraj