easypoi一对多导出excel

需要引用maven

		<dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-base</artifactId>
            <version>3.2.0</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-web</artifactId>
            <version>3.2.0</version>
        </dependency>
        <dependency>
            <groupId>cn.afterturn</groupId>
            <artifactId>easypoi-annotation</artifactId>
            <version>3.2.0</version>
        </dependency>

定义实体类

@Data
public class EmployeeRankDataEntity implements Serializable {


    @Excel(name="ems",width = 30,needMerge=true)
    private String emsNum;

    @Excel(name = "名称",width = 30,needMerge=true)
    private String username="";

    @Excel(name = "部门",width = 30,needMerge=true)
    private String deptName="";

	/**
	集合
	**/
   	@ExcelCollection(name = "")
    private List< EmployeeTimeData>times;

}

@Data
public class EmployeeTimeDataimplements implements  Serializable {


    @Excel(name="时间",width = 30,needMerge=true)
    private String time;

}

controller层

 	 ExportParams params = new ExportParams();
        params.setTitle("用户");
        Workbook workbook = ExcelExportUtil.exportExcel(params, EmployeeRankDataEntity.class, list);

        try {
            String fileName=System.currentTimeMillis()+".xls";
            response.setHeader("Content-Disposition", "attachment;filename=" + new String(fileName.getBytes(), "ISO8859-1"));
            response.setHeader("Pargam", "no-cache");
            response.setHeader("Cache-Control", "no-cache");
            ServletOutputStream outStream = null;
            try {
                outStream = response.getOutputStream();
                workbook.write(outStream);
                outStream.flush();
            } finally {
                outStream.close();
            }
        } catch (Exception e) {
            e.printStackTrace();
        }