参考 : 使用POI读取xlsx文件,包含对excel中自定义时间格式的处理 - Mr.ning - 博客园
private Date parse(String time) {
try {
Date date = org.apache.poi.ss.usermodel.DateUtil.getJavaDate(Double.parseDouble(time));
return date;
} catch (Exception e) {
return null;
}
}
time就是读取的值,读取方式可以参考下面
private String getCellValue(XSSFRow row, int cellPosition) {
XSSFCell cell = row.getCell(cellPosition);
if (null == cell) {
return Constants.CROSS_BAR;
}
CellType cellType = cell.getCellType();
String cellValue = null;
switch (cellType) {
case STRING:
cellValue = cell.getStringCellValue();
break;
case FORMULA:
cellValue = cell.getCellFormula();
break;
case NUMERIC:
cellValue = cell.getNumericCellValue() + "";
break;
default:
cellValue = cell.getStringCellValue();
break;
}
return cellValue;
}
row是行对象,cellPosition是列数,从0开始
END。