sheet.getLastRowNum() and sheet.getRows() are broken sheet.getLastRowNum() returns actual rows number - 1 (empty rows are not accounted - I's OK) sheet.getRows() returns all rows except last one
4.0.1 version
*** Bug 63157 has been marked as a duplicate of this bug. ***
getLastRowNum() is 0-based and it is reflected in the documentation. There isn't such a method getRows() in the Sheet interface. Do you mean that iteration over rows skips the last row? I don't think it is so and we have numerous unit tests that prove it. If you still think there is a bug, can you please attach a unit test demonstrating the problem? Regards, Yegor
We could not see anything being wrong in Apache POI here and no more information provided for a week, thus I am resolving this as WORKSFORME for now. If you still think there is a problem, then please reopen with some code-sample, ideally as self-sufficient unit-test which allows to reproduce your problem so we can see the actual problem more easily.