getcell().setCellValue() gives null pointer exception

Asked Jun 05 '16 at 19:02

Active Jun 05 '16 at 19:02

Viewed 12 times

I am getting a cell from excel sheet and then I have to set its value.

XSSFSheet sheet = workbook.getSheetAt(0);
 XSSFCell resultCell=null;

 if(   sheet.getRow(1).getCell('A')==null)
{ sheet.getRow(1).getCell('A').setCellValue("heh");}

But this gives a null pointer exception.

asked Jun 05 '16 at 19:02

puffles

So either `sheet` or `sheet.getRow(1)` is `null`. – Tunaki Jun 05 '16 at 19:04
@Tunaki it does get sheet in first statement. It raises this exception with in if block – puffles Jun 05 '16 at 19:07
Yes, because one of the two is `null`. If it isn't `sheet` then it is `sheet.getRow(1)`. – Tunaki Jun 05 '16 at 19:08
Why is it null (sheet.getRow())? – puffles Jun 05 '16 at 19:12

getcell().setCellValue() gives null pointer exception

0 Answers0