Missing cells in imported data.

[georgelappies]

Hi all

I am getting a null pointer exception looping through imported cells from Excel in my Java app.

Analysing the code in the debugger, one can indeed see that these cells have not been read:

As can be seen cell 16 is missing completely. This column is not hidden on the Excel spread sheet, in fact there is nothing special about it. As can be seen on the row below it where it imported:

I am using the following versions of the libraries:

<dependency>
            <groupId>org.jxls</groupId>
            <artifactId>jxls</artifactId>
            <version>2.12.0</version>
        </dependency>
        <dependency>
            <groupId>org.jxls</groupId>
            <artifactId>jxls-reader</artifactId>
            <version>2.0.6</version>
        </dependency>
        <dependency>
            <groupId>org.jxls</groupId>
            <artifactId>jxls-poi</artifactId>
            <version>2.12.0</version>
        </dependency>

Why would this happen?

[georgelappies]

Answering my own question with this link from the docs:

https://poi.apache.org/components/spreadsheet/quick-guide.html#Iterate+over+cells%2C+with+control+of+missing+%2F+blank+cells