https://bz.apache.org/bugzilla/show_bug.cgi?id=51781
--- Comment #4 from Anupriya <[email protected]> --- Created attachment 38184 --> https://bz.apache.org/bugzilla/attachment.cgi?id=38184&action=edit This file have empty rows This file has an empty row. and total of 11 rows So I am expecting below response : 1. getLastRowNum() --> 10 (as the count starts from 0 + it do consider the empty rows as mentioned in the doc : https://poi.apache.org/apidocs/dev/org/apache/poi/xssf/usermodel/XSSFSheet.html#getLastRowNum--) 2. getPhysicalNumberOfRows() --> 11 (actual output) but 10 (expected) as this should not consider the row with empty data. Otherwise there is no diff in these both instead of starting value. Empty row is not physical row, right? Also, while fetching data in a loop for a row, it is giving the empty row as null and so the NPE. Row currentRow = sheet.getRow(rowNum); // this is null for empty row. My point is: if the row is null, why it is considered in count for physical rows. -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
