easypoi导出excel

准备model

private Long id;

@Excel(name = "用户名称")

private String username;

public Long getId() {
    return id;
}

public void setId(Long id) {
    this.id = id;
}

public String getUsername() {
    return username;
}

public void setUsername(String username) {
    this.username = username;
}

public String getEmail() {
    return email;
}

public void setEmail(String email) {
    this.email = email;
}

@Excel(name = "邮件",width = 20)

private String email;

public EasyPOIModel(){}
public EasyPOIModel(Long id,String username,String email){
    this.id = id;
    this.username = username;
    this.email = email;
}

===============
@org.junit.Test
public void testExcel() throws Exception{
     //准备员工数据
    EasyPOIModel e1 = new EasyPOIModel();
    e1.setId(1L);
     e1.setUsername("junit");
     e1.setEmail("zhang@qq.com");
    EasyPOIModel e2 = new EasyPOIModel();
    e2.setId(2L);

    e2.setUsername("明明");
    e2.setEmail("li@qq.com");List<EasyPOIModel> list = new ArrayList<>();
    list.add(e1);
     list.add(e2);
    /**
          * 进行相应的展出
          *  参数1:一些基本配置(表头等)
          *  参数2:导出的类型
          *  参数3:导出的数据
     */
 Workbook workbook = ExcelExportUtil.exportExcel(new ExportParams(),EasyPOIModel.class, list);
//保存数据
FileOutputStream fos = new FileOutputStream("E:\\ttttttt.xls");
workbook.write(fos);
fos.close();
}