Easy Poi 导入多sheet页

效果

代码

	@ApiOperation("多sheet导入")
    @PostMapping(value = "/import", headers = "content-type=mutipart/form-data", consumes = MediaType.MULTIPART_FORM_DATA_VALUE)
    public void importSheet(@RequestParam("file") MultipartFile file) throws Exception {

        ImportParams importSheet1Params = new ImportParams();
        // 指定读取的sheet页(0开始，第一个)。
        importSheet1Params.setStartSheetIndex(0);
        // 读取sheet1的数据
        List<ExcelDTO1> sheet1Data = ExcelImportUtil.importExcel(file.getInputStream(), ExcelDTO1.class, importSheet1Params);
        log.info("sheet1 data size is {}",sheet1Data.size());


        ImportParams import2Sheet2Params = new ImportParams();
        // 指定读取的sheet页(第二个)。
        import2Sheet2Params.setStartSheetIndex(1);
        // 读取sheet2的数据
        List<ExcelDTO1> sheet2Data = ExcelImportUtil.importExcel(file.getInputStream(), ExcelDTO2.class, import2Sheet2Params);
        log.info("sheet2 data size is {}",sheet2Data.size());


        // 处理数据
        // ......

    }

@Data
public class ExcelDTO1{

    @Excel(name = "列表1",orderNum = "1")
    private String name;

    @Excel(name = "列表2",orderNum = "1")
    private String level;
}

@Data
public class ExcelDTO2{

    @Excel(name = "字段1",orderNum = "1")
    private String name;

    @Excel(name = "字段2",orderNum = "2")
    private String level;

    @Excel(name = "字段3",orderNum = "3")
    private String aaaa;
}