java 下载项目内的模板 excel

//后台代码
@GetMapping("fapiaoDownload")
@ApiOperation("下载模板")
@LogOperation("下载模板")
public void Download(HttpServletResponse response) throws Exception {
    // 取要下载的模板名称
    String fileName = "发票导入模板.xlsx";
    String address = "/excelTemplate/fapiaomuban.xlsx";
    //得到该文件
    ClassPathResource classPathResource = new ClassPathResource(address);
    InputStream fileInputStream = classPathResource.getInputStream();
    //设置Http响应头告诉浏览器下载这个附件,下载的文件名也是在这里设置的
    response.setHeader("Content-Disposition", "attachment;Filename=" + URLEncoder.encode(fileName, "UTF-8"));
    OutputStream outputStream = response.getOutputStream();
    byte[] bytes = new byte[2048];
    int len = 0;
    while ((len = fileInputStream.read(bytes)) > 0) {
        outputStream.write(bytes, 0, len);
    }
    fileInputStream.close();
    outputStream.close();
}

模板地址

 

前端代码

//下载模板
fapiaoDownload: function() {
  window.location.href = window.SITE_CONFIG['apiURL'] + '/bank/fapiao/fapiaoDownload' ;
},

然后浏览器操作