AutoPoi根据Excel模板导出问题


    @RequestMapping(value = "/exportXls")
    public ModelAndView exportXls(HttpServletRequest request, JmkjOrder jmkjOrder) {

        //获取模板文件
        TemplateExportParams params = new TemplateExportParams(
                System.getProperty("user.dir") + "/" + "27361.xls"
        );
        String selections = request.getParameter("selections");
        //获取导出数据
        JmkjOrder order = jmkjOrderService.getById(selections);
        //获取订单产品数据
        QueryWrapper q = new QueryWrapper();
        q.eq("good_code",order.getId());
        List<JmkjOrderGood> orderGoods = jmkjOrderGoodService.list(q);

        Map<String,Object> map = new HashMap<>();
        map.put("sydw",order.getDhrUnit());
        map.put("orderCode",order.getOrderCode());
        map.put("shr",order.getShrName()+order.getShrPhone());
        map.put("dz",order.getShAddress());
        map.put("xdtime",DateUtil.formatDate(order.getCreateTime()));

        List<Map<String, String>> listMap = new ArrayList<Map<String, String>>();
        String name = "";
        String model = "";

        for (int i = 0; i < orderGoods.size(); i++) {
            Map<String, String> lm = new HashMap<String, String>();
            //截取产品名称分为名称、型号
            int index= orderGoods.get(i).getName().indexOf("型");
            name = orderGoods.get(i).getName().substring(index+1, orderGoods.get(i).getName().length());
            model = orderGoods.get(i).getName().substring(0,index);

            lm.put("id", i + 1 + "");
            lm.put("name", name);
            lm.put("model", model);
            lm.put("num", orderGoods.get(i).getNum().toString());
            lm.put("ps", orderGoods.get(i).getPs());
            listMap.add(lm);
        }
        map.put("maplist", listMap);

        //导出Exce
        ModelAndView mv = new ModelAndView(new JeecgTemplateExcelView());
        mv.addObject(TemplateExcelConstants.FILE_NAME, "这是excel文件名称"); //此处设置的filename无效 ,前端会重更新设置一下
        mv.addObject(TemplateExcelConstants.PARAMS, params);//参数
        mv.addObject(TemplateExcelConstants.MAP_DATA, map);
        return mv;
    }

这是我的模板样式

img


我在导出的时候产品那一块出现问题

img


第二行没有显示数据,而且产品名称那单元格没有合并