Excel文件中日期为2021/12/28,解析出来变成了 28-十二月-2021
解析单元格Cell日期为具体天数
public static String getValue(Cell cell) {
if (cell.getCellType() == HSSFCell.CELL_TYPE_BOOLEAN) {
return String.valueOf(cell.getBooleanCellValue());
} else if (cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
double value = cell.getNumericCellValue();
return new BigDecimal(value).toString();
} else if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING) {
return String.valueOf(cell.getStringCellValue());
} else {
return String.valueOf(cell.getStringCellValue());
}
}
将具体天数转为格式化日期
public static String importByExcelForDate(String value) {//value就是它的天数
String currentCellValue = "";
if(value != null && !value.equals("")){
Calendar calendar = new GregorianCalendar(1900,0,-1);
Date d = calendar.getTime();
Date dd = DateUtils.addDays(d,Integer.valueOf(value));
DateFormat formater = new SimpleDateFormat("yyyy-MM-dd");
currentCellValue = formater.format(dd);
}
return currentCellValue;
}