导出

1.前端

location.href = urls.exportExg+"?namsNo="+namsNo+"&dataSource="+dataSource+"&chgTmsCnt="+chgTmsCnt;

2.后端代码

@RequestMapping(value = "/export_nams_exg",method = RequestMethod.GET)
public void exportNamsExg(HttpServletResponse response,String namsNo,Integer dataSource,Integer chgTmsCnt){
    try {
        Map<String,Object> data = new HashMap<>();
        /*获取成品数据*/
        if(EmsCommon.DATA_SOURCE_HIS==dataSource){
          List<NamsExgHis>  list = exgAppService.listNamsExgHis(namsNo,chgTmsCnt);
            data.put("list",list);
        }
        /*获取模板路径*/
        URL url =   ResourceUtils.getURL("classpath:exceltemplet/nams_exg_expt.xls");
        FileUtils.downloadTemplate(url.getPath(),data,"成品",response);
    }catch (Exception e){
        log.error(e.getMessage(),e);
        e.printStackTrace();
    }

工具代码

public static void downloadTemplate(String path, Map<String, Object> map, String fileName, HttpServletResponse response) {
    try {

        logger.info("路径:" + path);
        path = path.replaceAll("%20", " ");
        /*设置模板路径*/
        TemplateExportParams params = new TemplateExportParams(path);

        if (map == null) {
            map = new HashMap<>();
        }
        /*加载模板*/
        Workbook workbook = ExcelExportUtil.exportExcel(params, map);
        /*设置返回表头*/
        response.setCharacterEncoding("UTF-8");
        response.setHeader("content-Type", "application/vnd.ms-excel");
        response.setHeader("Content-Disposition",
            "attachment;filename=" + URLEncoder.encode(fileName + ".xls", "UTF-8"));
        workbook.write(response.getOutputStream());
    } catch (Exception e) {
        e.printStackTrace();
    }
}

3.导出excel模板