POI not returning all rows

[Gregor Kovač]

Hi!

I have an Excel file for which POI does not return all rows. The file is in
attachment.
I have tried with POI 3.11 and 3.15beta2 with same results.
Program I use:
        FileInputStream fis = null;

        try {
            File file = new
File("/home/gregor/tmp/smyk/LIVE4/POI_TEST.xls");
            fis = new FileInputStream(file);
            Workbook workBook = new HSSFWorkbook(fis);
            int activeSheet = workBook.getActiveSheetIndex();
            Sheet sheet1 = workBook.getSheetAt(activeSheet);

            for (Row row : sheet1) {
                System.out.println("#" + (row.getRowNum() + 1));
            }
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
            if (fis != null) {
                try {
                    fis.close();
                } catch (Exception e) {
                    e.printStackTrace();
                }
            }
        }


Output I get:
#1
#2
#3
#4
#5
#6
#7
#8
#9
#10
#11
#12
#13
#14
#15
#16
#17
#18
#20
#21
#22
#23

As you can see #19 is missing and if I open the Excel file in LibreOffice
or Excel I see row 19.
Why does POI not return it?

Best regards,
    Kovi

POI_TEST.xls
Description: MS-Excel spreadsheet

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscr...@poi.apache.org
For additional commands, e-mail: user-h...@poi.apache.org