【无标题】

根据自定义excel模板导出数据

public void getPfzbJcjlExport_v2(Map<String, Object> params, HttpServletResponse response) throws IOException {
        com.alibaba.excel.ExcelWriter excelWriter = null;
        try {
            String nd = MapUtil.getStr(params,"nd");
            String kssj = MapUtil.getStr(params,"kssj");
            String jssj = MapUtil.getStr(params,"jssj");
            String tempName = "药品批发企业、连锁总部监督检查情况统计";
            String btnf = "20xx";
            if (StringUtils.isNotBlank(nd)){
                btnf= nd;
            }
            /*if(StringUtils.isNotEmpty(jssj)){
                btnf = jssj.substring(0,4);
            }*/
            String sjd = "（xxxx.xx.xx —— xxxx.xx.xx）";
            if(StringUtils.isNotEmpty(jssj)&&StringUtils.isNotEmpty(kssj)){
                sjd = "（"+kssj+" —— "+jssj+"）";
            }
            if(StringUtils.isNotEmpty(jssj)&&StringUtils.isEmpty(kssj)){
                sjd = "（xxxx.xx.xx —— "+jssj+"）";
            }
            if(StringUtils.isEmpty(jssj)&&StringUtils.isNotEmpty(kssj)){
                sjd = "（"+kssj+" —— xxxx.xx.xx）";
            }

            //获取模板
            ClassPathResource classPathResource = new ClassPathResource("/template/jcwcqktjTemplate.xlsx");
            InputStream templateInput = classPathResource.getInputStream();
            //获取模板
            excelWriter = EasyExcel.write(response.getOutputStream()).withTemplate(templateInput).build();

            WriteSheet writeSheet = EasyExcel.writerSheet().build();
            //设置forceNewRow属性为true，表示在填充数据时，如果当前行已经有数据了，就强制换行填充
            FillConfig fillConfig = FillConfig.builder().forceNewRow(Boolean.TRUE).build();

            List<Map<String, Object>> list = wTjfxManager.countJdjcqktj(params);
            // 第二种占位符替换，这里定义了 hisData
            excelWriter.fill(new FillWrapper("mxData", list), writeSheet);

            // 第一种占位符替换
            Map<String, Object> map = new HashMap<>();
            map.put("year", btnf);
            map.put("jcsj", sjd);
            excelWriter.fill(map, writeSheet);
            // 设置响应头，告诉浏览器这是一个 Excel 文件下载
            response.setContentType("application/vnd.openxmlformats - officedocument.spreadsheetml.sheet");
            response.setCharacterEncoding("utf-8");
            String fileName = URLEncoder.encode(tempName+".xlsx", "utf-8");
            response.setHeader(HttpHeaders.CONTENT_DISPOSITION, "attachment; filename=\"" + fileName + "\"");
        }catch (Exception e) {
            e.printStackTrace();
            //throw new RuntimeException("列表生成失败，请联系管理员！");
        } finally {
            if (excelWriter != null) {
                excelWriter.finish();
            }
        }
    }

excel模板设置