public static String getCellValue(Cell cell) {
return getCellValue(cell, "yyyy-MM-dd HH:mm:ss");
}
/**
*
* Description: 获取单元格的值
* @param cell
* @param datetimeFormat
* @return 单元格中的值
*/
public static String getCellValue(Cell cell, String datetimeFormat) {
String value = "";
if (cell == null) {
return null;
}
switch (cell.getCellType()) {
case Cell.CELL_TYPE_NUMERIC:
if (DateUtil.isCellDateFormatted(cell)) {
value = DTimeUtils.formatDateToString(cell.getDateCellValue(), datetimeFormat);
} else {
cell.setCellType(Cell.CELL_TYPE_STRING);
value = cell.getStringCellValue();
}
break;
case Cell.CELL_TYPE_STRING:
value = cell.getRichStringCellValue() + "";
break;
case Cell.CELL_TYPE_FORMULA:
value = cell.getCellFormula();
break;
case Cell.CELL_TYPE_BOOLEAN:
value = cell.getBooleanCellValue() + "";
break;
}
return value.trim();
}
POI获取excel文件单元格中的值
最新推荐文章于 2024-07-05 14:30:10 发布