easypoi模版导出-表格最后一行被覆盖

解决方案：最后一行的下一行的第一个单元格加个空格

模版导出额Excel下载（集合若依的Excel的方法）

        Map<String,Object> map = new HashMap<>();
        if (CollectionUtils.isNotEmpty(list)) {
            // 表格最后一行统计
            map.put("totalVolume", list.size());
            map.put("totalWeight", XX);
            map.put("totalMeterQuantity", XX);
            map.put("totalYardage", XX);
        }
        List<Map> itemList = Lists.newArrayList();
        for (YardageRollInfoSummarizingDetailExportVo vo : list) {
            Map<String, Object> itemMap = BeanUtil.beanToMap(vo, new HashMap<>(), CopyOptions.create());
            itemList.add(itemMap);
        }
       map.put("itemList",itemList);

        TemplateExportParams params = new TemplateExportParams("contract/成品汇总明细模版.xlsx");
        Workbook wb = ExcelExportUtil.exportExcel(params, map);
        OutputStream out = null;
        try {
            String filename = ExcelUtil.formatFilename("xxxx");
            String filepath = ExcelUtil.getAbsoluteFile(filename);
            out = new FileOutputStream(filepath);
            wb.write(out);
            return AjaxResult.success(filename);
        } catch (Exception e) {
            log.error("导出Excel异常", e);
            throw new CustomException("导出Excel失败，请联系网站管理员！");
        } finally {
            if (wb != null) {
                try {
                    wb.close();
                } catch (IOException e1) {
                    e1.printStackTrace();
                }
            }
            if (out != null) {
                try {
                    out.close();
                } catch (IOException e1) {
                    e1.printStackTrace();
                }
            }
            map.clear();
        }

模版文件

导出结果