https://bz.apache.org/bugzilla/show_bug.cgi?id=60389
Javen O'Neal <one...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
Resolution|--- |INVALID
Status|NEW |RESOLVED
--- Comment #2 from Javen O'Neal <one...@apache.org> ---
getLastRowNum returns the row number of the last physical row in the sheet.
This is equivalent to Ctrl+Down in Excel
The Sheet interface doesn't have a function to get the last row containing at
least one non-blank cell.
You will need to iterate over the rows (ideally a reverse iterator) and iterate
over cells in each row to determine if that row is blank, then return the row
number of the last non-blank row. This sounds like it could be expensive.
You may want to look at
http://stackoverflow.com/questions/38204944/apache-poi-check-if-a-column-is-empty/38238218#38238218
for ideas on efficient iteration.
Since this is not a bug but a usage question, I. If you have more questions,
please ask them on u...@poi.apache.org mailing list.
https://poi.apache.org/mailinglists.html
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
