@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;
}
这是我的模板样式
我在导出的时候产品那一块出现问题
第二行没有显示数据,而且产品名称那单元格没有合并