1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49
| if(i!=0){ outExcelOrderDetail.get(i).setOId(""); outExcelOrderDetail.get(i).setOName(""); outExcelOrderDetail.get(i).setOPhone(""); outExcelOrderDetail.get(i).setOAddress(""); } outExcelOrderDetail.get(i).setMoney(outExcelOrderDetail.get(i).getMoney()+"元"); } ExcelUtil2 excelUtil=new ExcelUtil2(); List<JSONObject> columns = new ArrayList<>(); columns.add(excelUtil.defaultGetColumn("订单号", "oId", 15 * 256, false, false)); columns.add(excelUtil.defaultGetColumn("收货人", "oName", 15 * 256, false, false)); columns.add(excelUtil.defaultGetColumn("电话", "oPhone", 15 * 256, false, false)); columns.add(excelUtil.defaultGetColumn("地址", "oAddress", 26 * 256, false, false)); columns.add(excelUtil.defaultGetColumn("农资名", "sName", 15 * 256, false, false)); columns.add(excelUtil.defaultGetColumn("数量", "num", 12 * 256, false, false)); columns.add(excelUtil.defaultGetColumn("单价", "money", 12 * 256, false, false));
excelUtil.createSheet(workbook, outExcelOrderDetail, columns, "订单详情"); }
private void outputExcel(HttpServletResponse response, SXSSFWorkbook workbook, String excelName) { response.setContentType("application/vnd.ms-excel"); try { response.setHeader("content-disposition", "attachment;filename=" + new String(excelName.getBytes("GB2312"), "ISO-8859-1") + ".xlsx"); workbook.write(response.getOutputStream()); } catch (IOException e) { e.printStackTrace(); } } @RequestMapping("userOrderConfirm") @ResponseBody public String userOrderConfirm(HttpServletRequest request,int id,int typeNum){ int eId; if(typeNum==0){ eId = (int)request.getSession().getAttribute("adminId"); }else{ eId=0; } return ResponseUtil.successToClient(userService.upDateByorderConfirm(id,typeNum,eId)); }
} package com.snack.web;
|