Blank cells throwing null pointer exception while reading about excel-streaming-reader HOT 7 OPEN

I had a similar issue, I solved it like this:

Cell cell = row.getCell(i);
if (cell == null) {
cell = new StreamingCell(i, row.getRowNum());
}

this just creates a StreamingCell with null value and you can go from there.

edit// formatting (indentation does not seem to work here)

from excel-streaming-reader.

@andreasellervee thank you so much for your post. It helped me a lot. I was at the same issue and I could fix it by using your solution.
I realized when we use StreamingReader and iterate cells of a row, it does not consider cells with blank value, shifting to the next cell with valid value and messing the rest of columns out.

Just to exempify, I was considering the code below:

for (Row row : reader) {
            String[] recordArray = new String[totalColumns];
            int columnSheet = 0;
            for (Cell cell : row) {
                recordArray[columnSheet] = cell.getStringCellValue();
                columnSheet++;
            }

            listRegistration.add(recordArray);
        }

than I've changed to this, in order to work well:

for (Row row : reader) {
            String[] recordArray = new String[totalColumns];
            int columnSheet = 0;
            for (int i=0; i<totalColumns; i++) {
                Cell cell = row.getCell(i);
                if (cell == null) {
                    cell = new StreamingCell(i, row.getRowNum());
                }
                recordArray[columnSheet] = cell.getStringCellValue();
                columnSheet++;
            }

            listRegistration.add(recordArray);
        }

from excel-streaming-reader.

@waxxxd

Any thoughts on implementing setMissingCellPolicy:

  @Override
  public void setMissingCellPolicy(MissingCellPolicy missingCellPolicy) {
    throw new UnsupportedOperationException();
  }

on StreamingWorkbook? Then it wouldn't have to be passed in for every getCell call.

from excel-streaming-reader.

Hello abhilashreddy1289

Cell cell = row.getCell(i, Row.CREATE_NULL_AS_BLANK) is now supported and resolves the issue.

Hope this is good news.

from excel-streaming-reader.

Row.CREATE_NULL_AS_BLANK not working

from excel-streaming-reader.

Can you confirm that you are using the latest maven version 1.1.0.

If you are please provide the sheet and code. Then we can help you.

from excel-streaming-reader.

Hello @dlandis

I haven't really looked into the code too much. Committed the change to fix a bug I had encountered in a personal project. Have a crack at it.

from excel-streaming-reader.