读操作

@Data
public class DemoData {
    //设置excel表头的名称，第一个参数是列名称，第二个参数是第几列
    @ExcelProperty(value = "学号",index = 0)
    private Integer sno;
    @ExcelProperty(value = "姓名",index = 1)
    private String sname;
}

public class ExcelListener extends AnalysisEventListener<DemoData> {
    //一行一行的读取excel中的内容
    @Override
    public void invoke(DemoData data, AnalysisContext analysisContext) {
        System.out.println("********"+data);
    }
    //读取表头的方法
    public void invokeHeadMap(Map<Integer, String> headMap, AnalysisContext context) {
        System.out.println("*******表头："+headMap);
    }
    //读取完成之后要做的事情
    @Override
    public void doAfterAllAnalysed(AnalysisContext analysisContext) {
    }
}

@Test
public void readTest(){
    String filename = "E:\\MyProject\\javaProject\\guli_parent\\write.xlsx";
    EasyExcel.read(filename,DemoData.class,new ExcelListener()).sheet().doRead();
}