遂昌综合执法平台服务端
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
zhanghua
2023-03-18 0c4b37ef2de376e8d02fe81a6af384929579d662 
 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();


    }




}