From 2dad3e25f93f4307e53ed1ed8af64a826c7a3628 Mon Sep 17 00:00:00 2001
From: songhuangfeng123 <shf18767906695@163.com>
Date: 星期四, 04 八月 2022 11:08:06 +0800
Subject: [PATCH] 事故状态fix
---
goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/utils/poihelper/ExcelUtil.java | 8 +++++++-
1 files changed, 7 insertions(+), 1 deletions(-)
diff --git a/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/utils/poihelper/ExcelUtil.java b/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/utils/poihelper/ExcelUtil.java
index a8f9759..1b8b195 100644
--- a/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/utils/poihelper/ExcelUtil.java
+++ b/goal-manage/goal-manage-service/src/main/java/com/gkhy/safePlatform/targetDuty/utils/poihelper/ExcelUtil.java
@@ -19,6 +19,7 @@
import java.lang.reflect.Field;
import java.sql.Timestamp;
import java.text.MessageFormat;
+import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.*;
@@ -557,7 +558,12 @@
if(data != null){
value = Integer.parseInt(String.valueOf(data));
}
- } else {
+ }else if (field.getType().equals(Long.class)) {
+ Object data = getCellValue(cell);
+ if(data != null){
+ value = Long.parseLong(String.valueOf(data));
+ }
+ } else {
value = getCellValue(cell);
// 处理特殊情况,excel的value为String,且bean中为其他,且defaultValue不为空,那就=defaultValue
ExcelCell annoCell = field.getAnnotation(ExcelCell.class);
--
Gitblit v1.9.2