From 23e187554324e1bdff896d7d18634711a7372755 Mon Sep 17 00:00:00 2001
From: fuliqi <fuliqi@qq.com>
Date: 星期四, 12 十二月 2024 17:56:58 +0800
Subject: [PATCH] 项目库上传后端逻辑
---
common/src/main/java/com/ycl/common/utils/poi/ExcelUtil.java | 18 ++++++++++++++++++
1 files changed, 18 insertions(+), 0 deletions(-)
diff --git a/common/src/main/java/com/ycl/common/utils/poi/ExcelUtil.java b/common/src/main/java/com/ycl/common/utils/poi/ExcelUtil.java
index 4a13764..6347658 100644
--- a/common/src/main/java/com/ycl/common/utils/poi/ExcelUtil.java
+++ b/common/src/main/java/com/ycl/common/utils/poi/ExcelUtil.java
@@ -24,6 +24,10 @@
import java.util.UUID;
import java.util.stream.Collectors;
import javax.servlet.http.HttpServletResponse;
+
+import com.alibaba.excel.EasyExcel;
+import com.ycl.common.utils.excel.core.ExcelListener;
+import com.ycl.common.utils.excel.core.ExcelResult;
import org.apache.commons.lang3.ArrayUtils;
import org.apache.commons.lang3.RegExUtils;
import org.apache.commons.lang3.reflect.FieldUtils;
@@ -500,6 +504,20 @@
}
/**
+ * 浣跨敤鑷畾涔夌洃鍚櫒 寮傛瀵煎叆 鑷畾涔夎繑鍥�
+ *
+ * @param is 杈撳叆娴�
+ * @param clazz 瀵硅薄绫诲瀷
+ * @param listener 鑷畾涔夌洃鍚櫒
+ * @return 杞崲鍚庨泦鍚�
+ */
+ public static <T> ExcelResult<T> importExcel(InputStream is, Class<T> clazz, ExcelListener<T> listener) {
+ EasyExcel.read(is, clazz, listener).sheet().doRead();
+ return listener.getExcelResult();
+ }
+
+
+ /**
* 瀵筶ist鏁版嵁婧愬皢鍏堕噷闈㈢殑鏁版嵁瀵煎叆鍒癳xcel琛ㄥ崟
*
* @param list 瀵煎嚭鏁版嵁闆嗗悎
--
Gitblit v1.8.0