还没改完

baizonghao

2023-03-18 49c3bb0fc7875bb0c1f231a958fafc6a732fea40

 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();
    }

}