Get number of rows with Apache POI

Question

I try to count number of rows in a xls file with Apache POI. File contains 300 rows, but I get just 24 as output of both of these commands.

int noOfColumns = sh.getRow(0).getPhysicalNumberOfCells();
int noOfColumns = sh.getRow(0).getLastCellNum();

There aren't any empty rows between lines in file.

you are getting row #0 as a base and then wondering why you don't get the row number? try using ``sh.getFirstRowNum()`` and ``sh.getLastRowNum()`` to get first and last row indexes. And by the way, ``Sheet`` implements ``Iterable`` so you can write ``for(Row r : sh) {}`` — spi, Mar 21 '19 at 14:43

score 2 · Accepted Answer · answered Mar 28 '19 at 13:33

2

It gives right number of rows on a sheet:

int rnum = sheet.getLastRowNum() - sheet.getFirstRowNum();

answered Mar 28 '19 at 13:33

plaidshirt

1 Answers1