From 788f57c0f36ce4e625b068b5891c35ed8f8da2c7 Mon Sep 17 00:00:00 2001
From: whycxzp <perryhsu@163.com>
Date: 星期四, 15 九月 2022 16:08:00 +0800
Subject: [PATCH] 更新excel日期格式判断
---
src/main/java/com/whyc/service/SoftwareService.java | 10 +++++++++-
1 files changed, 9 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/whyc/service/SoftwareService.java b/src/main/java/com/whyc/service/SoftwareService.java
index e046e9c..0fd23d9 100644
--- a/src/main/java/com/whyc/service/SoftwareService.java
+++ b/src/main/java/com/whyc/service/SoftwareService.java
@@ -81,7 +81,15 @@
common.setBasedVersion(sheet.getRow(5).getCell(4).getStringCellValue());
common.setOwner(sheet.getRow(6).getCell(2).getStringCellValue());
- common.setFilingDate(sheet.getRow(6).getCell(4).getStringCellValue());
+ Cell cellFilingDate = sheet.getRow(6).getCell(4);
+ if(cellFilingDate.getCellType() == Cell.CELL_TYPE_NUMERIC){
+ Date dateCellValue = cellFilingDate.getDateCellValue();
+ common.setFilingDate(DateUtil.YYYY_MM_DD.format(dateCellValue));
+ System.out.println(dateCellValue);
+ }else {
+ cellFilingDate.setCellType(Cell.CELL_TYPE_STRING);
+ common.setFilingDate(cellFilingDate.getStringCellValue());
+ }
//鏈�鍚庝竴琛�,鍙栧彂甯冭鏄�
common.setReleaseNotes(sheet.getRow(lastRowNum).getCell(2).getStringCellValue());
--
Gitblit v1.9.1