EasyExcel初体验

<!--EasyExcel相关依赖-->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>easyexcel</artifactId>
    <version>3.0.5</version>
</dependency>

引入依赖

public class UserEntity {

    @ExcelProperty(value = "姓名")
    private String name;
 
    @ExcelProperty(value = "年龄")
    private int age;
 
    @DateTimeFormat("yyyy-MM-dd HH:mm:ss")//时间范例
    @ExcelProperty(value = "操作时间")
    private Date time;
 

}

 

定义实体类

    public static void export(List<User> list){
        String date = DateUtil.getDate(1);
        {//写入excel
            List<User> dataList = new ArrayList<>();
            for (int i = 0; i < list.size(); i++) {
                User user = list.get(i);
                dataList.add(user);
            }
            //定义文件输出位置
            FileOutputStream outputStream = null;
            try {
                outputStream = new FileOutputStream("filepath\\测试表_"+date+".xls");
                EasyExcel.write(outputStream,AccessRecord.class).sheet("用户信息").doWrite(dataList);
            } catch (FileNotFoundException e) {
                e.printStackTrace();
            }
        }
    }

操作类

在上面的代码，曾报过EasyExcel的Classnotfound，但后面测试是缓存问题，清理重启idea即可。。。