java导出Excel(使用阿里巴巴的easyexcel)

1. 第一步导入maven依赖

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

2. 第二部创建数据模型（实体类）

@Data
@AllArgsConstructor
public class ExcelEntity {
    @ExcelProperty("姓名 （字符串）")
    private String name;
    @ExcelProperty("生日（时间）")
    private Date birthday;
    @ExcelProperty("年龄（数字）")
    private Integer age;
}

3. 第三步写Controller

@GetMapping("/getExcel")
public void getExcel(HttpServletResponse response) throws IOException {
    List<ExcelEntity> list =  new ArrayList<>(5);
    for (int i=1;i<=10; i++){
        list.add(new ExcelEntity("张"+i,new Date(),i));
    }
    response.setContentType("application/vnd.ms-excel");
    response.setCharacterEncoding("utf-8");
    String fileName = URLEncoder.encode("导出表格", "UTF-8");
    response.setHeader("Content-disposition", "attachment;fileName=" + fileName + ".xlsx");
    EasyExcel.write(response.getOutputStream(), ExcelEntity.class).sheet("模板").doWrite(list);
}

4. 第四步测试

访问地址：http://localhost:8080/excel/getExcel

成功结果

有问题质询QQ:248048521,欢迎技术交流