POI XSSF class Throws NullPointerException when createCell or setCellValue to empty row in existing Excel

Asked Aug 29 '16 at 07:39

Active Aug 29 '16 at 07:50

Viewed 25 times

If Existing Excel's row is fill with data then .. below code will execute and override the data.. CODE :

            rowsline= sourceSheet.getRow(RowNo);
            rowsline.createCell(CellNo);
            rowsline.getCell(CellNo).setCellValue(DataValue);
            outputStream = new FileOutputStream(file);
            srcBook.write(outputStream);

ERROR :

      Exception in thread "main" java.lang.NullPointerException
      at Source_Program.SourceProgram.SetDataInExcel(SourceProgram.java:146)

edited Aug 29 '16 at 07:50

asked Aug 29 '16 at 07:39

Eddie Singh

which is line 146? – Scary Wombat Aug 29 '16 at 07:40
146 line - rowsline.createCell(CellNo); – Eddie Singh Aug 29 '16 at 07:51
well in that case `rowsline= sourceSheet.getRow(RowNo);` failed – Scary Wombat Aug 29 '16 at 07:57
No.. it's working.. createCell() is function that returns the Nullpointer.. when Excel Cell is empty.... – Eddie Singh Aug 29 '16 at 08:01
don't know how to handle it .. when excel Cell is filled with data.. then code override data.. and execute program successfully ... NullpointerException only occurred when Cell is Empty – Eddie Singh Aug 29 '16 at 08:03
my code `Cell cell = sh.getRow(1).getCell(cellNum); if (cell != null) { cell.setCellType(Cell.CELL_TYPE_BLANK); }` – Scary Wombat Aug 29 '16 at 08:13
M doing it with XSSF class - poi-3.15-beta2 and it's not working... – Eddie Singh Aug 29 '16 at 08:17
Done ... Firstly need to check whether row is empty or not... is row is empty and need to add new row and after that.. need to cell and set data... Thanks Scary Wombat... – Eddie Singh Aug 29 '16 at 08:56
Well done. Glad it works for you. – Scary Wombat Aug 29 '16 at 08:57

POI XSSF class Throws NullPointerException when createCell or setCellValue to empty row in existing Excel

0 Answers0