EasyExcel初体验

    com.alibaba
    easyexcel
    3.0.5

引入依赖

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 list){
        String date = DateUtil.getDate(1);
        {//写入excel
            List 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即可。。。