SimpleDateFormat sdf = new SimpleDateFromat("yyyy-MM-dd");
Workbook workbook = new XSSFWorkbook(new FileInputStream("D:/test.xslx"));
Sheet sheet = workbook.getSheetAt(0);
Row row = sheet.getRow(0);
Cell cell = row.getCell(0);
System.out.println(sdf.format(cell.getDateCellValue()));
cell = row.getCell(1);
double dateNumber = cell.getNumbericCellValue();
Date date = DateUtil.getJavaDate(dateNumber);
String formateDate = sdf.format(date);
System.out.println(formateDate);
Java 获取 excel 计算公式日期后的数字结果转换
最新推荐文章于 2025-12-04 17:40:34 发布
6248

被折叠的 条评论
为什么被折叠?



