From 75f7bbb31181096988b4310ca84654b880f50604 Mon Sep 17 00:00:00 2001
From: baizonghao <1719256278@qq.com>
Date: 星期五, 17 三月 2023 21:51:21 +0800
Subject: [PATCH] 部门管理的导入导出
---
ycl-common/src/main/java/com/ycl/utils/EasyExcelUtils.java | 12 ++++++++++++
1 files changed, 12 insertions(+), 0 deletions(-)
diff --git a/ycl-common/src/main/java/com/ycl/utils/EasyExcelUtils.java b/ycl-common/src/main/java/com/ycl/utils/EasyExcelUtils.java
index 05e51c3..d479f54 100644
--- a/ycl-common/src/main/java/com/ycl/utils/EasyExcelUtils.java
+++ b/ycl-common/src/main/java/com/ycl/utils/EasyExcelUtils.java
@@ -1,9 +1,13 @@
package com.ycl.utils;
import com.alibaba.excel.EasyExcel;
+import com.ycl.dto.UmsDepartDto;
+import com.ycl.utils.listener.DepartListener;
import lombok.SneakyThrows;
+import org.springframework.web.multipart.MultipartFile;
import javax.servlet.http.HttpServletResponse;
+import java.io.IOException;
import java.time.LocalDateTime;
import java.time.format.DateTimeFormatter;
import java.util.Collection;
@@ -25,4 +29,12 @@
.sheet(sheetName)
.doWrite(collection);
}
+
+ @SneakyThrows
+ public static void importDepartFile(MultipartFile file) throws IOException {
+ EasyExcel.read(file.getInputStream())
+ .head(UmsDepartDto.class)
+ .registerReadListener(new DepartListener()).sheet().doRead();
+ }
+
}
--
Gitblit v1.8.0