From eeb5e9e815592e45305b491a71e0c6aced7cb381 Mon Sep 17 00:00:00 2001
From: zxl <763096477@qq.com>
Date: 星期四, 20 三月 2025 09:53:46 +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