easyexcel 读取

@Data
public class importUserPj  extends BaseRowModel {

    @ExcelProperty(value = "工号",index = 0)
    @NumberFormat(value = "0")
    private String jobCode;

    @ExcelProperty(index = 1)
    private String nickName;

    @ExcelProperty(index =2)
    private String joinTimeStr;

    @ExcelProperty(index =3)
    private String xueLi;
    @ExcelProperty(index =4)
    private String ziGe;
    @ExcelProperty(index =5)
    private String zhiWu;

}

/**
 * 解析监听器，
 * 每解析一行会回调invoke()方法。
 * 整个excel解析结束会执行doAfterAllAnalysed()方法
 */
@Slf4j
@Data
@NoArgsConstructor
@AllArgsConstructor
public class ExcelListener<T> extends AnalysisEventListener<T> {

    /**
     * 自定义存储表格数据
     */
    private List<T> dataList = new ArrayList<>();
    /**
     * 自定义存储标题结果
     */
    private T titleMap;


    @Override
    public void invoke(T result, AnalysisContext context) {
        //获取当前行号
        Integer rowIndex = context.readRowHolder().getRowIndex();
        if (rowIndex == 0) {
            this.titleMap = result;
        } else {
            //数据存储到list，供批量处理，或后续自己业务逻辑处理。
            if (result instanceof QuestionsExcelData) {
                // 校验等等
            }
            dataList.add(result);
        }
        log.info("解析数据第{}行，数据为：{}", rowIndex, result);
    }

    @Override
    public void doAfterAllAnalysed(AnalysisContext analysisContext) {
        // list.clear();//解析结束销毁不用的资源
        // 处理业务数据插入表 还是校验等等
        log.info("解析完成！");
    }

}

@RestController
@RequestMapping("/system/user")
public class importUser {


    @PostMapping("/importData")
    public BaseResult importu(MultipartFile file, boolean updateSupport) throws IOException {
        InputStream inputStream = file.getInputStream();
        //实例化实现了AnalysisEventListener接口的类
        ExcelListener listener = new ExcelListener();
        //传入参数
        ExcelReader excelReader = new ExcelReader(inputStream, ExcelTypeEnum.XLS, null, listener);
        //读取信息
        excelReader.read(new Sheet(2, 1, importUserPj.class));
//        excelReader.read(new Sheet(3, 1, importUserPj.class));
//        excelReader.read(new Sheet(4, 1, importUserPj.class));
//        excelReader.read(new Sheet(5, 1, importUserPj.class));

        //获取数据
        List<importUserPj> list = listener.getDataList();



        return null;

    }
}