模板填充横向数据覆盖问题

[Untiluuu]

String json = "[{"assistanceCount":0,"minorCount":1,"assistanceMinorCount":0,"gender":"女","adultCount":0,"nation":"","documentNumber":"52052420141219224X","takeCareCompletely":0,"populationTotalCount":1,"remark":"","oldPeopleCount":0,"phoneNo":"16658587741","totalNursing":0,"disabledCount":0,"populationSalvationCount":1,"applyName":"单人保5.-15-1","address":"123","salvationTotalAmt":600.00,"applyIdCard":"52052420141219224X","householdEnjoy":"是","index":12,"womenCount":1,"salvageType":"1|困难户","semiNursing":0,"createTime":"2025年06月16日","personEnjoysAssistance":0,"amountTempTotal":0},{"assistanceCount":0,"minorCount":0,"assistanceMinorCount":0,"gender":"女","adultCount":0,"nation":"","documentNumber":"522624194204040967","takeCareCompletely":0,"populationTotalCount":1,"remark":"","oldPeopleCount":1,"phoneNo":"15547478854","totalNursing":0,"disabledCount":0,"populationSalvationCount":1,"applyName":"低边6.12-1.1（底边中的单人保）","address":"123","salvationTotalAmt":200.00,"applyIdCard":"522624194204040967","householdEnjoy":"是","index":18,"womenCount":1,"salvageType":"1|困难户","semiNursing":0,"createTime":"2025年06月16日","personEnjoysAssistance":0,"amountTempTotal":0}\n" +
",{"assistanceCount":0,"minorCount":0,"assistanceMinorCount":0,"gender":"女","adultCount":1,"nation":"","documentNumber":"520322195104238160","takeCareCompletely":0,"populationTotalCount":4,"remark":"","oldPeopleCount":2,"familyMemberName2":"高合金钢","familyMemberName1":"城市人","phoneNo":"16658587741","totalNursing":0,"disabledCount":0,"populationSalvationCount":3,"applyName":"验证城乡类型","address":"123","salvationTotalAmt":2037.48,"applyIdCard":"520322195104238160","householdEnjoy":"是","index":19,"womenCount":2,"salvageType":"1|困难户","semiNursing":0,"createTime":"2025年06月16日","familyMemberId1":"522327197910082837","personEnjoysAssistance":0,"familyMemberId2":"520327196308107265","amountTempTotal":0}\n" +
",{"assistanceCount":0,"minorCount":0,"assistanceMinorCount":0,"salvationTotalAmt":0.00,"adultCount":0,"index":20,"takeCareCompletely":0,"populationTotalCount":1,"remark":"46456456","oldPeopleCount":0,"phoneNo":"15525259980","womenCount":0,"totalNursing":0,"salvageType":"1|困难户","semiNursing":0,"createTime":"2025年06月16日","disabledCount":0,"personEnjoysAssistance":0,"populationSalvationCount":1,"amountTempTotal":0}\n" +
",{"assistanceCount":0,"minorCount":0,"assistanceMinorCount":0,"salvationTotalAmt":0.00,"adultCount":0,"index":21,"takeCareCompletely":0,"populationTotalCount":1,"remark":"6+56+","oldPeopleCount":0,"phoneNo":"15547472200","womenCount":0,"totalNursing":0,"salvageType":"1|困难户","semiNursing":0,"createTime":"2025年06月16日","disabledCount":0,"personEnjoysAssistance":0,"populationSalvationCount":1,"amountTempTotal":0}\n" +
",{"assistanceCount":0,"minorCount":0,"assistanceMinorCount":0,"gender":"女","adultCount":0,"nation":"","documentNumber":"520525194507026985","takeCareCompletely":0,"populationTotalCount":2,"remark":"789","oldPeopleCount":2,"familyMemberName1":"规划局","phoneNo":"16658587741","totalNursing":0,"disabledCount":0,"populationSalvationCount":2,"applyName":"低保5.15-1","address":"123","salvationTotalAmt":766.66,"applyIdCard":"520525194507026985","householdEnjoy":"是","index":22,"womenCount":2,"salvageType":"1|困难户","semiNursing":0,"createTime":"2025年06月16日","familyMemberId1":"520181193810199488","personEnjoysAssistance":0,"amountTempTotal":0}\n" +
",{"assistanceCount":0,"minorCount":0,"assistanceMinorCount":0,"gender":"女","adultCount":1,"nation":"","documentNumber":"520121194106301248","takeCareCompletely":0,"populationTotalCount":2,"remark":"","oldPeopleCount":1,"familyMemberName1":"456","phoneNo":"16658587741","totalNursing":0,"disabledCount":0,"populationSalvationCount":2,"applyName":"低保6.11-2","address":"123","salvationTotalAmt":1316.66,"applyIdCard":"520121194106301248","householdEnjoy":"是","index":23,"womenCount":1,"salvageType":"1|困难户","semiNursing":0,"createTime":"2025年06月16日","familyMemberId1":"522728200007239431","personEnjoysAssistance":0,"amountTempTotal":0}\n" +
",{"assistanceCount":0,"minorCount":1,"assistanceMinorCount":0,"gender":"女","adultCount":0,"nation":"","documentNumber":"52032420080924652X","takeCareCompletely":0,"populationTotalCount":1,"remark":"","oldPeopleCount":0,"phoneNo":"15585887412","totalNursing":0,"disabledCount":0,"populationSalvationCount":1,"applyName":"测试5.12-1","address":"户籍地址户籍地址户籍地址","salvationTotalAmt":633.33,"applyIdCard":"52032420080924652X","householdEnjoy":"是","index":24,"womenCount":1,"salvageType":"1|困难户","semiNursing":0,"createTime":"2025年06月16日","personEnjoysAssistance":0,"amountTempTotal":0},\n" +
"{"assistanceCount":0,"minorCount":0,"assistanceMinorCount":0,"gender":"女","adultCount":1,"nation":"","documentNumber":"522629197101194803","takeCareCompletely":0,"populationTotalCount":1,"remark":"","oldPeopleCount":0,"phoneNo":"16658587741","totalNursing":0,"disabledCount":0,"populationSalvationCount":1,"applyName":"验证公示表1","address":"123","salvationTotalAmt":658.33,"applyIdCard":"522629197101194803","householdEnjoy":"是","index":28,"womenCount":1,"salvageType":"1|困难户","semiNursing":0,"createTime":"2025年06月16日","personEnjoysAssistance":0,"amountTempTotal":0}\n" +
",\n" +
"{"assistanceCount":0,"minorCount":0,"assistanceMinorCount":0,"gender":"女","adultCount":2,"nation":"苗族","documentNumber":"361129199610121945","takeCareCompletely":0,"populationTotalCount":3,"remark":"测试","oldPeopleCount":0,"familyMemberName1":"詹芷蕊","phoneNo":"18831788685","totalNursing":0,"disabledCount":0,"populationSalvationCount":2,"applyName":"颛孙妙彤","address":"123","salvationTotalAmt":1213.34,"applyIdCard":"361129199610121945","householdEnjoy":"是","index":29,"womenCount":2,"salvageType":"1|困难户","semiNursing":0,"createTime":"2025年06月16日","familyMemberId1":"230103197811284967","personEnjoysAssistance":0,"amountTempTotal":0}\n" +
",{"assistanceCount":0,"minorCount":0,"assistanceMinorCount":0,"gender":"女","adultCount":0,"nation":"","documentNumber":"522628194903108188","takeCareCompletely":0,"populationTotalCount":1,"remark":"","oldPeopleCount":1,"phoneNo":"16658587741","totalNursing":0,"disabledCount":0,"populationSalvationCount":1,"applyName":"临时救助+低保","address":"12313","salvationTotalAmt":616.67,"applyIdCard":"522628194903108188","householdEnjoy":"是","index":30,"womenCount":1,"salvageType":"1|困难户","semiNursing":0,"createTime":"2025年06月16日","personEnjoysAssistance":0,"amountTempTotal":0}\n" +
"]";

    List<JSONObject> jsonObjects = JSONArray.parseArray(json).toList(JSONObject.class);
    // 从resources目录读取模板文件
    String templateFileName = ("C:\\Users\\dcb\\Desktop\\1.城低.xlsx");
    String fileName = "C:\\Users\\dcb\\Desktop\\" + "test" + System.currentTimeMillis() + ".xlsx";
    try (ExcelWriter excelWriter = EasyExcel.write(fileName).withTemplate(templateFileName).build()) {
        WriteSheet writeSheet = EasyExcel.writerSheet().build();
        FillConfig fillConfig = FillConfig.builder().forceNewRow(Boolean.TRUE).direction(WriteDirectionEnum.VERTICAL).build();
        excelWriter.fill(new FillWrapper("familyList", jsonObjects), fillConfig, writeSheet);
    } catch (
            Exception e) {
        e.printStackTrace();easyexcel
    }

第一条数据的familyMemberName1为空 第三条数据familyMemberName1不为空 则第三条的数据familyMemberName1会填充到第一行
easyexcel版本3.3.3