EasyExcel多sheet页导入导出

VIP文章鲸语丶

已于 2022-04-29 17:30:37 修改

阅读量654

点赞数 2

文章标签： java 开发语言

于 2022-04-29 17:25:09 首次发布

本文链接：https://blog.csdn.net/hushilin_/article/details/124500291

版权

EasyExcel多sheet页导入导出

一、导入依赖

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>easyexcel</artifactId>
    <version>2.1.6</version>
</dependency>

二、随便整个application.yml

server:
  # 服务器的HTTP端口
  port: 8080

三、拿两个DO举例

@Data
public class Student {
   

    @ExcelProperty(value = "学生姓名")
    private String studentName;

    @ExcelProperty(value = "科室号码")
    private Integer classNum;
}

@Data
public class User {
   

    @ExcelProperty(value = "用户名")
    private String name;

    @ExcelProperty(value = "年龄")
    private Integer age;
}

四、controller

@RestController
public class EasyController {
   


    /**
     * http://localhost:8080/export
     * desciption 多sheet导出
     */
    @GetMapping("/export")
    public void export(HttpServletResponse response) {
   
        try {
   
            response.setContentType("application/vnd.ms-excel");
            response.setCharacterEncoding("utf-8");
            String fileName = URLEncoder.encode("test", "UTF-8")