如何使用poi获取包含空白单元格的行号

Question

我在读一个excel文件。我希望得到空单元格的行和列号，如果有类似的：

A      B     C      D         E

Jen  John  Alex 03-11-95  {BLANK}

这里我想要空白单元格的行和列索引，我试了很多东西但都不成功

                List<Student> listStudent = new ArrayList<>();
                FileInputStream inputStream = new FileInputStream(file);

                Workbook workbook = new XSSFWorkbook(inputStream);
                Sheet firstSheet = workbook.getSheetAt(0);
                Iterator<Row> iterator = firstSheet.iterator();

                while (iterator.hasNext()) {
                    Row nextRow = iterator.next();
                    Iterator<Cell> cellIterator = nextRow.cellIterator();
                    Student student = new Student();

                    while (cellIterator.hasNext()) {
                        Cell nextCell = cellIterator.next();
                        int columnIndex = nextCell.getColumnIndex();             

                        if (!firstName.contains("not_in_file") && columnIndex == Integer.parseInt(firstName)) {
                            student.setFirstName((String) getCellValue(nextCell));
                        } else if (!familyName.contains("not_in_file") && columnIndex == Integer.parseInt(familyName)) {
                            student.setFamilyName((String) getCellValue(nextCell));
                        } else if (!preferName.contains("not_in_file") && columnIndex == Integer.parseInt(preferName)) {
                            student.setPreferName((String) getCellValue(nextCell));
                        } else if (!dob.contains("not_in_file") && columnIndex == Integer.parseInt(dob)) {
                            student.setDob((String) getCellValue(nextCell));
                        } else if (!guardianName.contains("not_in_file") && columnIndex == Integer.parseInt(guardianName)) {
                            student.setGuardianName((String) getCellValue(nextCell));
                        }

                    }
                    listStudent.add(student);
                }
                System.out.println(" listStudent : " + listStudent);
                workbook.close();
                inputStream.close();



private Object getCellValue(Cell cell) {
        switch (cell.getCellType()) {
        case Cell.CELL_TYPE_STRING:
            return cell.getStringCellValue();

        case Cell.CELL_TYPE_BOOLEAN:
            return cell.getBooleanCellValue();

        case Cell.CELL_TYPE_NUMERIC:
            return cell.getNumericCellValue();
        }

        return null;
    }

Answer 1

有一个细胞常数。可以将cell.cell_type_blank大小写添加到getCellValue方法中。

private Object getCellValue(Cell cell) {
    switch (cell.getCellType()) {
    case Cell.CELL_TYPE_BLANK:
        return "";
    case Cell.CELL_TYPE_STRING:
        return cell.getStringCellValue();

    case Cell.CELL_TYPE_BOOLEAN:
        return cell.getBooleanCellValue();
    case Cell.CELL_TYPE_NUMERIC:
        return cell.getNumericCellValue();

    }

    return null;
}