| Summary: | setting null value to date cell leads to NPE | ||
|---|---|---|---|
| Product: | POI | Reporter: | jupp.strunk |
| Component: | XSSF | Assignee: | POI Developers List <dev> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | ||
| Priority: | P2 | ||
| Version: | 3.14-FINAL | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | All | ||
When setting a Date value in a cell and the date is null, a NullPointerException is thrown. Example: private void createRow(Sheet sheet, Person person) { Row row = sheet.createRow(0); Cell cell = row.createCell(0); cell.setCellValue(person.getBirthdate()); ... If person.getBirthdate() is null we get a NPE: java.lang.NullPointerException at java.util.Calendar.setTime(Calendar.java:1770) at org.apache.poi.ss.usermodel.DateUtil.getExcelDate(DateUtil.java:76) at org.apache.poi.xssf.usermodel.XSSFCell.setCellValue(XSSFCell.java:742) My workaround is to check for null and in this case set cell.setCellValue((String) null); However, in my opinion Cell.setCellValue(Date value) should take care of this, just like Cell.setCellValue(String value)