EasyExcel自定义样式生成Excel

EasyExcel是一个基于Java的简单、省内存的读写excel的开源项目。在尽可能节约内存的情况下支持读写百M的excel.官方文档地址为：https://www.yuque.com/easyexcel/doc/easyexcel

 EasyExcel生成excel

1、定义实体类（模板）

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import lombok.Data;

@Data
public class StudentTable {

    @ColumnWidth(20)
    @ExcelProperty(value="姓名",index=0)
    private String studentName;

    @ColumnWidth(20)
    @ExcelProperty(value = "年龄",index = 1)
    private int studentAge;

    @ColumnWidth(20)
    @ExcelProperty(value = "年级",index = 2)
    private String studentGrade;

    @ColumnWidth(20)
    @ExcelProperty(value = "家庭住址",index = 3)
    private String studentAdress;
}