java - HSSF 读取空白单元格得到空指针异常

Question

我正在开发将 excel 工作表内容转储到数据库的实用程序(在我的例子中是 postgres 9.2)，当所有单元格都已填满时，应用程序运行非常顺利，但每当我尝试在 excel 上运行我的代码时有空单元格的工作表给了我 NULL POINTER EXCEPTION 。谁能帮帮我……？

代码....剪辑...

public ArrayList fillList(int colIndex, int id, List<Cell> cells,
        String path) {
    // OrderedMap errorMap=new LinkedMap();
    String error = null;
    ArrayList<String> errorList = new ArrayList<String>();
    // errorList=null;
    try {
        FileInputStream fileIn = new FileInputStream(path);

        POIFSFileSystem fs;

        fs = new POIFSFileSystem(fileIn);

        HSSFWorkbook filename = new HSSFWorkbook(fs);
        Cell number = null;
        HSSFSheet sheet = filename.getSheetAt(0);
        Row firstRow = sheet.getRow(0);
        int flag = 0;

        String errorValue = null;

        int columnNo = colIndex;
        if (columnNo != -1) {
            for (Row row : sheet) {
                if (row.getRowNum() != 0) {
                    Cell c = row.getCell(columnNo);
                   // row.getCell(arg0, arg1)
                    // cells.add(c);
                    System.out.println(c.getCellType());
                    if (c.getCellType() == Cell.CELL_TYPE_STRING && 
                             (id == 2 || id == 3)) {
                        cells.add(c);
                    } else if (c.getCellType() == Cell.CELL_TYPE_NUMERIC
                            && id == 1) {
                        String s = row.getCell(columnNo).toString();
                        double d = Double.parseDouble(s);
                        String mob = Double.toString(d);
                        Cell sc = row.createCell((short) 2);
                        String text = NumberToTextConverter.toText(c
                                .getNumericCellValue());
                        // System.out.println(text);
                        sc.setCellValue(text);
                        cells.add(sc);
                        // Date date=c.getDateCellValue();

                    } else if (c.getCellType() == Cell.CELL_TYPE_NUMERIC && id == 4) {
                        String s = row.getCell(columnNo).toString();
                        double d = HSSFDateUtil.getExcelDate(c
                                .getDateCellValue());
                        // String date = Double.toString(d);
                        Cell sc = row.createCell((short) 2);
                        String date = new SimpleDateFormat("dd-MM-yyyy")
                                .format(c.getDateCellValue());
                        // System.out.println(text);
                        sc.setCellValue(date);
                        cells.add(sc);

                    } 
                    else if (c.getCellType() == Cell.CELL_TYPE_BLANK && id == 1   ) {
                        String s = row.getCell(columnNo).toString();
                        Cell sc = row.createCell((short)2);
                        sc.setCellValue("-");
                        cells.add(sc);

                    }
                    else {
                        switch (c.getCellType()) {
                        case Cell.CELL_TYPE_NUMERIC:
                            errorValue = Double.toString(c
                                    .getNumericCellValue());
                            break;
                        case Cell.CELL_TYPE_STRING:
                            errorValue = c.getStringCellValue();
                            break;
                        }

                        errorList.add(c.getRowIndex() + "$" + columnNo
                                + "$" + errorValue + "$" + id);
                    }
                    /*
                     * if (c == null || c.getCellType() ==
                     * Cell.CELL_TYPE_BLANK) { cells.add(c); } else {
                     * 
                     * cells.add(c);
                     * 
                     * }
                     */

                    flag = 1;
                }// if to skip 1st row
            }
        } else {
            // System.out.println("could not find column " + columnWanted +
            // " in first row of " + fileIn.toString());
        }
        return errorList;
    } catch (IOException e) {

        e.printStackTrace();
    } finally {
    }
    return errorList;
}

Answer 1

如果您不知道如何在单元格上测试空值，那么如果它在某行上抛出 NPE，您应该准备测试空值。

  if (c == null)

如果这真的行不通，那么你当然可以随时捕获 NPE

  try {
      cellType = c.getCellType();
  } catch (NullPointerException e) {
       // oops Null
       // do something else.
  }