Java Null pointer exception thrown when checking length of blank excel cell

Question

Context: Null pointer exception thrown when checking the length of blank excel cell.

Please help to fix the exception.

int lastRowNum = sh.getLastRowNum();

for (int i = 1; i < (lastRowNum+1); i++) {
    Row row = sh.getRow(i);
    System.out.println(i);
    // Null pointer exception throws for below if condition
    if (row.getCell(0).toString().length() == 0) {
        actions.operations(objectRepository, row.getCell(1).toString(), row.getCell(2).toString(), row.getCell(3).toString(), row.getCell(4).toString());

    }
    else {
        System.out.println("Test Case: " + row.getCell(0).toString() + " Started");
    }

}

Possible duplicate of [What is a NullPointerException, and how do I fix it?](http://stackoverflow.com/questions/218384/what-is-a-nullpointerexception-and-how-do-i-fix-it) — Pradeep Simha, Mar 18 '17 at 14:07

score 0 · Accepted Answer · answered Mar 18 '17 at 14:11

0

Add null check in if condition.

if(row.getCell(0) ==null || row.getCell(0).toString().length()==0){

answered Mar 18 '17 at 14:11

SANTOSHKUMAR SINGH

476
3
11

Java Null pointer exception thrown when checking length of blank excel cell

1 Answers1