easyexcel 上传下载

ゝ一纸荒年。 2023-03-02 07:40 49阅读 0赞

--------------------

### easyexcel 上传下载 ###

### \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* ###

**示例**

**\*\*\*\*\*\*\*\*\*\*\*\*\*\*\***

**pojo 层**

**Person**

@Data
    public class Person {
    
        private Integer id;
        private String name;
        private Integer age;
    }

**\*\*\*\*\*\*\*\*\*\*\*\*\*\*\***

**config 层**

**WebConfig**

@Configuration
    public class WebConfig implements WebMvcConfigurer {
    
        @Override
        public void addViewControllers(ViewControllerRegistry registry) {
            registry.addViewController("/index").setViewName("index");
        }
    }

**CustomListener**

public class CustomListener extends AnalysisEventListener<Person> {
    
        @Override
        public void invoke(Person data, AnalysisContext context) {
            System.out.println(data);
        }
    
        @Override
        public void doAfterAllAnalysed(AnalysisContext context) {
            System.out.println("数据解析完成");
        }
    }

**\*\*\*\*\*\*\*\*\*\*\*\*\*\*\***

**controller 层**

**HelloController**

@RestController
    public class HelloController {
    
        @RequestMapping("/upload")
        public Map<String,Object> upload(MultipartFile file){
                                                       //参数的名称设置为file
            
            Map<String,Object> result=new HashMap<>();
    
            try {
                EasyExcel.read(file.getInputStream(), Person.class,new CustomListener()).sheet().doRead();
    
                result.put("code",0);
                result.put("msg","上传成功");
            }catch (Exception e){
                result.put("code",1);
                result.put("msg",e.getMessage());
            }
    
            return result;
        }
    
        @RequestMapping("/download")
        public void download(HttpServletResponse response) throws Exception{
            response.setContentType("application/vnd.ms-excel");
            response.setCharacterEncoding("utf-8");
    
            String fileName= URLEncoder.encode("测试数据", StandardCharsets.UTF_8);
            response.setHeader("Content-disposition","attachment;filename="+fileName+".xlsx");
    
            EasyExcel.write(response.getOutputStream(),Person.class).sheet().doWrite(data());
        }
    
        private List<Person> data(){
            List<Person> list=new ArrayList<>();
    
            for (int i=0;i<5;i++){
                Person person=new Person();
                person.setId(i);
                person.setName("瓜田李下 "+i);
                person.setAge(20+i);
    
                list.add(person);
            }
    
            return list;
        }
    }

**\*\*\*\*\*\*\*\*\*\*\*\*\*\*\***

**前端页面**

![20200728174957112.png][]

**index.html**

<!DOCTYPE html>
    <html lang="en" xmlns="http://www.w3.org/1999/xhtml"
          xmlns:th="http://www.thymeleaf.org" xmlns:sec="https://www.thymeleaf.org/thymeleaf-extras-springsecurity4">
    <head>
        <meta charset="UTF-8">
        <title>Title</title>
        <link rel="stylesheet" href="/layui/css/layui.css">
        <script src="/layui/layui.js"></script>
    </head>
    <script>
        layui.use(["upload","layer"],function () {
            const upload = layui.upload;
            const layer = layui.layer;
    
            upload.render({
                elem: "#btn",
                url: "/upload",
                accept: "file",
                done: function (result) {
                    layer.msg(result.msg,{icon:6})
                }
            })
        })
    </script>
    
    <body>
    <div th:align="center">
        <button id="btn" class="layui-btn">
            <i class="layui-icon layui-icon-upload"></i>上传文件
        </button>
    </div>
    </body>
    </html>

### \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\* ###

**使用测试**

**\*\*\*\*\*\*\*\*\*\*\*\*\*\*\***

**上传文件**

**localhost:8080/index**

![20200728175307534.png][]

**上传文件**

![20200728175653183.png][]

**点击上传文件，文件上传后，控制台输出**

Person(id=0, name=瓜田李下0, age=20)
    Person(id=1, name=瓜田李下1, age=21)
    Person(id=2, name=瓜田李下2, age=22)
    Person(id=3, name=瓜田李下3, age=23)
    Person(id=4, name=瓜田李下4, age=24)
    Person(id=5, name=瓜田李下5, age=25)
    数据解析完成

**\*\*\*\*\*\*\*\*\*\*\*\*\*\*\***

**下载文件**

**localhost:8080/download**

![20200728180141202.png][]

![20200728180159792.png][]

[20200728174957112.png]: /images/20230208/ad12221c31ee40b4bb3da5cb67327a89.png
[20200728175307534.png]: /images/20230208/cccf4d6c3da741dea2e3e88be025032b.png
[20200728175653183.png]: /images/20230208/c416f9da61684a1ab82de33fa1d79199.png
[20200728180141202.png]: /images/20230208/a627c4f00ab74ff8959e38265ee727e4.png
[20200728180159792.png]: /images/20230208/a7c1af602ea046b9950ad08d5d8879b0.png