EasyExcel读写操作

1.导入依赖

<!-- https://mvnrepository.com/artifact/com.alibaba/easyexcel -->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>easyexcel</artifactId>
    <version>2.1.1</version>
</dependency>

2.新建实体类，字段属性对应表中的列

public class User {
    @ExcelProperty(value = "学生ID")
    private int id;
    @ExcelProperty(value = "学姓名")
    private String name;
}

3.写操作测试

@Test
public void test1(){
    ArrayList<User> users = new ArrayList<>();
    for (int i = 0; i <10 ; i++) {
        User user = new User();
        user.setId(i);
        user.setName("wang"+i);
        users.add(user);
    }
    String file="E:\\test.xlsx";
    EasyExcel.write(file,User.class).sheet("表1").doWrite(users);

}

3.结果

 

 2.读操作

　　1.实体类注解列数下标

public class User {
    @ExcelProperty(value = "学生ID",index = 0)
    private int id;
    @ExcelProperty(value = "学姓名",index = 1)
    private String name;
}


　　2.自定义监听器

public class ExcelListener extends AnalysisEventListener<User> {
    @Override
    public void invoke(User user, AnalysisContext analysisContext) {
        System.out.println(user);

    }

    @Override
    public void doAfterAllAnalysed(AnalysisContext analysisContext) {
        System.out.println(analysisContext.currentReadHolder());

    }
}

3.测试读操作

@Test
public void test2()
{
    String file="E:\\test.xlsx";
    EasyExcel.read(file,User.class, new ExcelListener()).sheet().doRead();


}