springboot 使用 EasyExcel 通过模板导出EXCEL 带多个动态列表

@GetMapping(value = "/exportDynamicExcel")
    @ApiOperation(value = "导出动态表格")
    public void exportDynamicExcel(HttpServletResponse response,@RequestParam Long id) throws IOException {
        // 查询数据库信息
        ConstraintValueOrderInfoDTL dtl = constraintValueOrderInfoService.getById(id);
        String dynamicFieldValue = dtl.getDynamicFieldValue();
        if (Objects.isNull(dynamicFieldValue)) {
            throw new CustomException("没有动态表单数据", getClass().toString());
        }
        List<DynamicFiledVO> dynamicFiledVOS = JSONObject.parseArray(dynamicFieldValue, DynamicFiledVO.class);
        List<DynamicFiledVO> textVos = dynamicFiledVOS.stream()
                .filter(e -> DynamicFiledTypeDict.TEXT.getCode().equals(e.getFiledType())).collect(Collectors.toList());
        List<DynamicFiledVO> tableVos = dynamicFiledVOS.stream()
                .filter(e -> DynamicFiledTypeDict.TABLE.getCode().equals(e.getFiledType())).collect(Collectors.toList());
        Map<String, String> textMap = new HashMap<>();
        for (DynamicFiledVO textVo : textVos) {
            textMap.put(textVo.getFiledName(), textVo.getFiledValue().toString());
        }

        //我把模板文件放到了resource下面了，所以读取resource下的模板文件 && 这里也可以是从服务器获取到的文件
        InputStream inputStream = ResourceUtil.getResourceObj("execlTemplate/导出excel示例模板.xlsx").getStream();
        ServletOutputStream outputStream = response.getOutputStream();
        // 设置创建行的方式
        FillConfig fillConfig = FillConfig.builder().forceNewRow(Boolean.TRUE).build();
        FillConfig fillConfig2 = FillConfig.builder().forceNewRow(Boolean.FALSE).build();
        ExcelWriter excelWriter = EasyExcel.write(outputStream).withTemplate(inputStream).excelType(ExcelTypeEnum.XLSX).build();
        // 写入到sheet
        WriteSheet oneSheet = EasyExcel.writerSheet(0).build();
        // 填充
        excelWriter.fill(textMap, oneSheet);
        for (int i = 0; i < tableVos.size(); i++) {
            List<DynamicFiledVO> subFiledInfo = tableVos.get(i).getSubFiledInfo();
            List<Map> filedValue = JSONObject.parseArray(JSONObject.toJSONString(tableVos.get(i).getFiledValue()), Map.class);
            // 只有两个属性 就一行重复显示一次
            // 例如: 序号    定值项名称    定值    序号    定值项名称    定值
            if (subFiledInfo.size() == 2) {
                // 拆分成两类列 还要带序号
                List<Map> list1 = new ArrayList<>();
                List<Map> list2 = new ArrayList<>();
                for (int i1 = 1; i1 <= filedValue.size(); i1++) {
                    Map map = filedValue.get(i1-1);
                    map.put("num", i1);
                    if (i1 % 2 != 0) {
                        list1.add(map);
                    } else {
                        // 第二行 列增加标识 避免填充出错
                        Map map2 = new HashMap();
                        Set set = map.keySet();
                        for (Object o : set) {
                            map2.put(o + "2", map.get(o));
                        }
                        list2.add(map2);
                    }
                }
                excelWriter.fill(list1, fillConfig, oneSheet);
                excelWriter.fill(list2, fillConfig2, oneSheet);
            }
        }
        // 设置响应头信息
        String fileName = "导出excel示例.xlsx";
        response.setHeader("Content-Disposition", "attachment;filename*=utf-8''" + URLEncoder.encode(fileName, StandardCharsets.UTF_8));
        response.setContentType("application/octet-stream");
        //关流
        excelWriter.finish();
        IOUtils.closeQuietly(inputStream);
        IOUtils.closeQuietly(outputStream);
    }

[
    {
      "filedDesc": "高压侧差动CT变比",
      "filedName": "gaoyacechadongCTbianhua",
      "filedType": "text",
      "filedOrder": 1,
      "filedStruct": null,
      "filedValue": "高压侧差动CT变比-值"
    },
    {
      "filedDesc": "中压侧差动CT变比",
      "filedName": "zhongyacechadongCTbianhua",
      "filedType": "text",
      "filedOrder": 2,
      "filedStruct": null,
      "filedValue": "中压侧差动CT变比-值"
    },
    {
      "filedDesc": "差动定值清单",
      "filedName": "chadongdingzhiqingdan",
      "filedType": "table",
      "filedOrder": 3,
      "subFiledInfo": [{ "filedDesc": "定值项名称", "filedName": "constraintValueName", "filedType": "tableHeader", "filedOrder": 1, "filedValue": "" },{ "filedDesc": "定值", "filedName": "constraintValueValue", "filedType": "tableHeader", "filedOrder": 2, "filedValue": "" }],
      "filedValue": [{"constraintValueName": "表单示例数据1", "constraintValueValue": 50},{"constraintValueName": "表单示例数据2", "constraintValueValue": 20},{"constraintValueName": "表单示例数据3", "constraintValueValue": 30}]
    }
  ]