easyexcel多sheet页读取

最新推荐文章于 2024-05-08 00:01:22 发布

xiaojing5576

最新推荐文章于 2024-05-08 00:01:22 发布

阅读量625

点赞数

文章标签： linux 运维服务器

本文链接：https://blog.csdn.net/xiaojing5576/article/details/134318175

版权

@PostMapping("/upload")
    public BaseResponse<String> uploadBaseData(MultipartFile file){
        InputStream inputStream = null;

        try{
            inputStream = file.getInputStream();
            ExcelReader excelReader = EasyExcel.read(inputStream).build();
            Base1DataListener base1DataListener = new Base1DataListener();
            Base2DataListener base2DataListener = new Base2DataListener();

            ReadSheet sheet0 = EasyExcel.readSheet(0)
                    .head(Base1DataExcelModel.class)
                    .registerConverter(new BigdecimalConverter())
                    .registerReadListener(base1DataListener)
                    .build();
            ReadSheet sheet1 = EasyExcel.readSheet(1)
                    .head(Base2DataExcelModel.class)
                    .registerConverter(new BigdecimalConverter())
                    .registerReadListener(base2DataListener)
                    .build();
            excelReader.read(sheet0,sheet1);
            excelReader.finish();

            List<Base1DataExcelModel> base1Models = base1DataListener.getData();
            List<Base2DataExcelModel> base2Models = base2DataListener.getData();

        }catch (Exception e){

        }
        return new BaseResponse("200","ok",true);

    }