From c59ca4c858387a73c626cc7cb995ed57fdea69f8 Mon Sep 17 00:00:00 2001
From: baizonghao <1719256278@qq.com>
Date: 星期六, 18 三月 2023 13:56:45 +0800
Subject: [PATCH] 用户导入
---
ycl-common/src/main/java/com/ycl/utils/EasyExcelUtils.java | 13 ++++++++++++-
1 files changed, 12 insertions(+), 1 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..50156d9 100644
--- a/ycl-common/src/main/java/com/ycl/utils/EasyExcelUtils.java
+++ b/ycl-common/src/main/java/com/ycl/utils/EasyExcelUtils.java
@@ -1,15 +1,18 @@
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;
public class EasyExcelUtils {
-
/**
* @Description 瀵煎嚭
@@ -25,4 +28,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