Java 获取 excel 计算公式日期后的数字结果转换

️无聊的猫

于 2024-11-07 16:26:20 发布

阅读量124

点赞数 1

CC 4.0 BY-SA版权

文章标签：笔记

本文链接：https://blog.youkuaiyun.com/lixin2yy/article/details/142378835

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);