poi导入时，导入后格式自动变为数字39776(已解决)

poi导入时,java导入后格式自动变为数字39776(已解决)

首先感谢博主(Tlimited)给于的帮助

链接: https://blog.csdn.net/u014204541/article/details/90580507.

我是用的是POI,做的导入(希望对各位朋友有帮助)

首先需要将表格中关于时间的格式更改为常规;
未改变前:

先更改为:

在这里的时候就改变成,可以通过getStringValue()获取值

// 获取carObtainDate里面的值
String carObtainDate = row.getCell(6).getStringCellValue();//carObtainDate ="39776";
// 获取carStartDate 里面的值
String carStartDate = row.getCell(7).getStringCellValue();//carStartDate ="39801";

import org.apache.poi.hssf.usermodel.HSSFDateUtil;

//输出获取到carObtainDate的值
 System.out.println("carObtainDate:--------------------"+carObtainDate);
 //输出获取到carStartDate的值
 System.out.println("carStartDate:--------------------"+carStartDate);
 //转换carObtainDate为Double
 System.out.println("Double.parseDouble(carObtainDate):"+Double.parseDouble(carObtainDate));
 //转换carStartDate为Double
 System.out.println("Double.parseDouble(carStartDate):"+Double.parseDouble(carStartDate));
 //HSSFDateUtil(自己上百度查吧)
 //将已转为Double类型的carObtainDate转为时间类型
 System.out.println("SSFDateUtil.getJavaDate(Double.parseDouble(carObtainDate));"+HSSFDateUtil.getJavaDate(Double.parseDouble(carObtainDate)));
 //将已转为Double类型的carStartDate转为时间类型
 System.out.println("SSFDateUtil.getJavaDate(Double.parseDouble(carStartDate));"+HSSFDateUtil.getJavaDate(Double.parseDouble(carStartDate)));

输出结果:

欧了,希望对各位有帮助.