EasyPoi 使用

1.在Maven中引入easypoi

<!-- easypoi的支持 -->

<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>

2.准备一个类

@Excel:代表这个字段要生成到excel中去

name:这个excel的表头名称

width:这一列的宽度设置

public class Employee implements Serializable {
   



    private Long id;

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

    private String username;

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

    private String email;

   // 省略了getter,setter

}

功能测试

@Test

public void testExcel() throws Exception{
   

    //准备员工数据

    Employee e1 = new Employee();

    e1.setId(1L);

    e1.setUsername("张三");

    e1.setEmail("zhang@qq.com")