From 0b08933a8c742e6f839a279e0ea24e7d5cb1cc2e Mon Sep 17 00:00:00 2001
From: RuoYi <yzz_ivy@163.com>
Date: Tue, 15 Mar 2022 14:42:44 +0800
Subject: [PATCH] 优化导出数据LocalDateTime类型无数据问题
---
ruoyi-common/ruoyi-common-core/src/main/java/com/ruoyi/common/core/utils/poi/ExcelUtil.java | 32 ++++++++++++++++++++------------
1 files changed, 20 insertions(+), 12 deletions(-)
diff --git a/ruoyi-common/ruoyi-common-core/src/main/java/com/ruoyi/common/core/utils/poi/ExcelUtil.java b/ruoyi-common/ruoyi-common-core/src/main/java/com/ruoyi/common/core/utils/poi/ExcelUtil.java
index ca2b196..aa475e3 100644
--- a/ruoyi-common/ruoyi-common-core/src/main/java/com/ruoyi/common/core/utils/poi/ExcelUtil.java
+++ b/ruoyi-common/ruoyi-common-core/src/main/java/com/ruoyi/common/core/utils/poi/ExcelUtil.java
@@ -284,7 +284,7 @@
String dateFormat = field.getAnnotation(Excel.class).dateFormat();
if (StringUtils.isNotEmpty(dateFormat))
{
- val = this.parseDateToStr(dateFormat, (Date) val);
+ val = parseDateToStr(dateFormat, val);
}
else
{
@@ -296,7 +296,7 @@
{
val = Convert.toInt(val);
}
- else if (Long.TYPE == fieldType || Long.class == fieldType)
+ else if ((Long.TYPE == fieldType || Long.class == fieldType) && StringUtils.isNumeric(Convert.toStr(val)))
{
val = Convert.toLong(val);
}
@@ -703,7 +703,7 @@
String separator = attr.separator();
if (StringUtils.isNotEmpty(dateFormat) && StringUtils.isNotNull(value))
{
- cell.setCellValue(this.parseDateToStr(dateFormat, (Date) value));
+ cell.setCellValue(parseDateToStr(dateFormat, value));
}
else if (StringUtils.isNotEmpty(readConverterExp) && StringUtils.isNotNull(value))
{
@@ -1158,25 +1158,33 @@
}
/**
- * 增加ExcelUtil对java8 日期的支持
- * 格式化日期，日期可能是：{@link Date}、{@link LocalDateTime}、 {@link LocalDate} 其他日期暂不支持
+ * 格式化不同类型的日期对象
+ *
* @param dateFormat 日期格式
* @param val 被格式化的日期对象
- * @see DateUtils#parseDateToStr(String, Date)
+ * @return 格式化后的日期字符
*/
- private String parseDateToStr(final String dateFormat, Object val)
+ public String parseDateToStr(String dateFormat, Object val)
{
- if (val == null) {
+ if (val == null)
+ {
return "";
}
String str;
- if (val instanceof Date) {
+ if (val instanceof Date)
+ {
str = DateUtils.parseDateToStr(dateFormat, (Date) val);
- } else if (val instanceof LocalDateTime) {
+ }
+ else if (val instanceof LocalDateTime)
+ {
str = DateUtils.parseDateToStr(dateFormat, DateUtils.toDate((LocalDateTime) val));
- } else if (val instanceof LocalDate) {
+ }
+ else if (val instanceof LocalDate)
+ {
str = DateUtils.parseDateToStr(dateFormat, DateUtils.toDate((LocalDate) val));
- } else {
+ }
+ else
+ {
str = val.toString();
}
return str;
--
Gitblit v1.9.3