即使单元格有值，Celliterator.hasNext（）也返回false

Question

InputStream inputStream = new BufferedInputStream(multipartFile.getInputStream());
XSSFWorkbook myWorkBook = new XSSFWorkbook(inputStream);
List<String> cellList = new ArrayList<>();
XSSFSheet mySheet = myWorkBook.getSheetAt(0);

Iterator<Row> rowIterator = mySheet.iterator();
rowIterator.next();

while (rowIterator.hasNext()) {
    Row row = rowIterator.next();
    cellList.clear();
    Iterator<Cell> cellIterator = row.cellIterator();

    while (cellIterator.hasNext()) { // this returns false even the cell has data 
        Cell cell = cellIterator.next();
        cellList.add(cell.getStringCellValue());
    }
}

Create Date  Uuid                                  Name
2021-09-29   2e81a2b6-3226-4fe0-b8bd-39f42239686d  admin
2021-09-30   610e9040-840c-48c5-aa64-f193ed896133  

Answer 1

对于空的“name”单元格，不能使celliterator.hasnext()返回true。

如果预先知道列的数量，则可以使用循环和row.getcell(index)。

        for (int i = 0; i < 3; i++) {
            Cell cell = row.getCell(i);
            cellList.add(cell == null ? "Empty":cell.toString());
        }

如果没有，则必须首先扫描文件以计算列数。