easyexcel导入excel

@Test
void test1(){
    List<ShippingScheduleExcel> dataList = new LinkedList<ShippingScheduleExcel>();
    //指定读取的文件
    ExcelReaderBuilder builder = EasyExcel.read("C:\\Users.\\xxx.xlsx");
    //自动关闭流
    builder.autoCloseStream(true);
    //指定excel文件的type
    builder.excelType(ExcelTypeEnum.XLSX);
    //注册数据读取后处理的监听器
    builder.registerReadListener(new MyListener2(dataList));
    //指定标题与属性的对应关系的class
    builder.head(ShippingScheduleExcel.class);
    //读取文件
    builder.doReadAll();
    //打印获取到的数据
    directScheduleMapper.insertShippingScheduleCxcel(dataList);
}

class MyListener2 extends AnalysisEventListener<ShippingScheduleExcel> {

    private List<ShippingScheduleExcel> dataList ;

    public MyListener2(List<ShippingScheduleExcel> dataList){
        this.dataList = dataList ;
    }

    public void invoke(ShippingScheduleExcel data, AnalysisContext context) {
        dataList.add(data);
    }

    public void doAfterAllAnalysed(AnalysisContext context) {
    
    }
}