Count Row

[zaidysf]

What is the best way to count rows on importing excel without header?

[dandragut]

Wouldn't this work? Headers are just rows, but you should know how many are expected or you can determine them yourself based on containing texts and subtract them from the total number of rows.

ReadableWorkbook workbook    = new ReadableWorkbook(inputStream);
Sheet            worksheet   = workbook.getFirstSheet();
List<Row>        rows        = worksheet.read();
int              numRows     = rows.size();