protected Object getCellValue(Row r, int cellNum) {
Cell cell = r.getCell(cellNum, Row.MissingCellPolicy.CREATE_NULL_AS_BLANK);
Object obj = null;
CellType cellType = cell.getCellType();
switch (cellType) {
case STRING:
obj = cell.getRichStringCellValue().getString();
break;
case NUMERIC:
if (DateUtil.isCellDateFormatted(cell)) {
obj = cell.getDateCellValue();
break;
}
obj = Double.valueOf(cell.getNumericCellValue());
break;
case BOOLEAN:
obj = Boolean.valueOf(cell.getBooleanCellValue());
break;
case FORMULA:
obj = cell.getCellFormula();
break;
}
return obj;
}
POI 读取单元格数据的方法
最新推荐文章于 2024-04-15 19:09:04 发布