{{小仓鼠爱攒食物}}EasyPOI

 @Test
    public void easypoiOutputTest() throws Exception{
        Hero hero1 = new Hero("1", "李白", new Date(), 19);
        Hero hero2 = new Hero("2", "赵云", new Date(), 19);

        List<Hero> list = new ArrayList<>();
        list.add(hero1);
        list.add(hero2);

        Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams("英雄名单","打野位" ),Hero.class,list);

        workbook.write(new FileOutputStream(new File("d:/easypoiOutputTest.xls")));
    }

package com.baizhi.entity;

import cn.afterturn.easypoi.excel.annotation.Excel;
import cn.afterturn.easypoi.excel.annotation.ExcelIgnore;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.experimental.Accessors;

import java.io.Serializable;
import java.util.Date;

@Data
@Accessors(chain = true)
@AllArgsConstructor
@NoArgsConstructor
public class Hero implements Serializable {

    //@Excel(name = "id")
    @ExcelIgnore
    private String id;
    @Excel(name = "名字")
    private String name;
    @Excel(name = "生日")
    private Date bir;
    @Excel(name = "年龄")
    private Integer age;

}

 @Test
    public void easypoiOutput1Test() throws Exception{

        Hero hero1 = new Hero("1", "李白", new Date(), 19);
        Hero hero2 = new Hero("2", "赵云", new Date(), 19);
        List<Hero> list = new ArrayList<>();
        list.add(hero1);
        list.add(hero2);

        Summoner summoner1 = new Summoner("1", "QGHappyCat", list);
        Summoner summoner2 = new Summoner("2", "TS暖阳", list);
        List<Summoner> summonerArrayList = new ArrayList<>();
        summonerArrayList.add(summoner1);
        summonerArrayList.add(summoner2);


        Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams("召唤师名单","打野位","王者荣耀人气职业选手" ),Summoner.class,summonerArrayList);

        workbook.write(new FileOutputStream(new File("d:/easypoiOutput1Test.xls")));
    }

package com.baizhi.entity;

import cn.afterturn.easypoi.excel.annotation.Excel;
import cn.afterturn.easypoi.excel.annotation.ExcelCollection;
import cn.afterturn.easypoi.excel.annotation.ExcelTarget;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import lombok.experimental.Accessors;

import java.io.Serializable;
import java.util.List;

@Data
@Accessors(chain = true)
@AllArgsConstructor
@NoArgsConstructor
@ExcelTarget(value = "召唤师")
public class Summoner implements Serializable {

    @Excel(name = "ID")
    private String id;
    @Excel(name = "NAME")
    private String name;
    @ExcelCollection(name = "英雄大名单")
    private List<Hero> heroes;
}