POI 获取单元格内容

最新推荐文章于 2024-12-19 10:34:22 发布

原创最新推荐文章于 2024-12-19 10:34:22 发布 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#string

Apache POI 专栏收录该内容

6 篇文章

订阅专栏

Sheet sheet1 = wb.getSheetAt(0);

for (Row row : sheet1) {

	for (Cell cell : row) {

		CellReference cellRef = new CellReference(row.getRowNum(), cell.getCellNum());

		System.out.print(cellRef.formatAsString());

		System.out.print(" - ");

		

		switch(cell.getCellType()) {

      case Cell.CELL_TYPE_STRING:

        System.out.println(cell.getRichStringCellValue().getString());

        break;

      case Cell.CELL_TYPE_NUMERIC:

        if(DateUtil.isCellDateFormatted(cell)) {

          System.out.println(cell.getDateCellValue());

        } else {

          System.out.println(cell.getNumericCellValue());

        }

        break;

      case Cell.CELL_TYPE_BOOLEAN:

        System.out.println(cell.getBooleanCellValue());

        break;

      case Cell.CELL_TYPE_FORMULA:

        System.out.println(cell.getCellFormula());

        break;

      default:

        System.out.println();

		}

	}

}