Vue请求后端接口导出excel表格方式

fetchGet1(url, params) {
    return axios({
      url,
      method: 'get',
      params,
      header: {
        headers: { 'Content-Type': 'application/x-download' }
      },
      responseType: 'blob'	//指明返回格式
    })
  }

//下载接口
export var downLoadOrder = (orderId) => ajax.fetchGet1(`/api/order/excel/${orderId}`)

@ApiOperation(value="导出模板")
    @RequestMapping(value="/getTemplate" , method= RequestMethod.GET)
    @ResponseBody
    public void getTemplate(httpservletRequest req,HttpServletResponse res) throws IOException {
        standingBookService.getTemplate(req, res);
    }

    public void getTemplate(HttpServletRequest req, HttpServletResponse res) throws IOException {
        String templateName = "standingBookTemplate";
        String exportName = "template";
        
        ExcelUtil.downloadExcelTemplate(req, res, templateName, exportName);
    }

    
    public static void downloadExcelTemplate(HttpServletRequest req,HttpServletResponse res,String templateName,
        String exportName) throws IOException{
        
        String fullFileName = req.getServletContext().getRealPath("/doc/import/excelTemplate");
        fullFileName += (File.separator + templateName + ".xls");
        
        String export = "";
        if(DataValidUtil.isEmpty(exportName)){
            export = templateName;
        }else{
            export = exportName;
        }
        
        String userAgent = req.getHeader("USER-AGENT");
        //文件下载乱码问题
        if (StringUtils.contains(userAgent.toUpperCase(),"MSIE")||StringUtils.contains(userAgent,"Trident")) {  
            export = URLEncoder.encode(export, "UTF-8");  
        } else {  
            export = new String(export.getBytes("UTF-8"), "ISO8859-1");  
        } 
        
        //设置Content-Disposition
        res.setHeader("Content-disposition","attachment; filename="+export+".xls");
        
        //设置文件MIME类型 
        //res.setContentType("application/vnd.ms-excel");
        //前端框架自定义类型
        res.setContentType("application/export.file");
        
            OutputStream out = res.getOutputStream();
            FileInputStream in = new FileInputStream(fullFileName);
            res.setCharacterEncoding("UTF-8");
            
            byte[] b = new byte[1024];
            int n = -1;
            
            while((n=in.read(b))!=-1){
                out.write(b, 0, n);
            }
            
            in.close();
            out.close();
    }

//模板下载
getTemplate(){
  const that = this;
  window.location='/test/test/getTemplate';//正确写法，直接访问你的请求路径
//这种写法会导致后台不报错，但是前端无导出效果

},