本文共 3806 字，大约阅读时间需要 12 分钟。

前端： 

html:      
   
        
    
     下载模板
          
   
js:      downloadDemo () {        let url = Config.context + '/userManager/downloadExcel'        this.common.exportData(url, this.queryForm, '数据模板_' + this.common.getTime())      }

exportData (url, data, fileName) {    axios({      method: 'POST',      url: url,      data: data,      responseType: 'blob'    }).then(response => {      if (!response) {        return      }      const blob = new Blob([response.data])      if (window.navigator && window.navigator.msSaveOrOpenBlob) {        navigator.msSaveBlob(blob, fileName)      } else {        let u = window.URL.createObjectURL(response.data)        let aLink = document.createElement('a')        aLink.style.display = 'none'        aLink.href = u        aLink.setAttribute('download', fileName + '.xlsx')        document.body.appendChild(aLink)        aLink.click()        document.body.removeChild(aLink)        window.URL.revokeObjectURL(u)      }    }).catch(error => {      throw error    })  }

后端：

controller层：

@RequestMapping("/downloadExcel")    public ResponseEntity
   
     download2() throws IOException {        File file = excelModelService.buildXlsById();        return FileUtils.buildResponseEntity(file);    }
   

service层：

import org.springframework.stereotype.Service;import org.springframework.util.ResourceUtils;import java.io.File;import java.io.FileNotFoundException;@Servicepublic class ExcelModelService {    public File buildXlsById(){        //do something to find this file        File file=null;        try {            file = ResourceUtils.getFile("classpath:templates/model.xlsx");        } catch (FileNotFoundException e) {            e.printStackTrace();        }        return file;    }}

这里写的是静态文件的存放路径，注意不能中文名不然识别不了

文件下载工具类：

public static ResponseEntity
   
     buildResponseEntity(File file) throws IOException {        byte[] body = null;        //获取文件        InputStream is = new FileInputStream(file);        body = new byte[is.available()];        is.read(body);        HttpHeaders headers = new HttpHeaders();        //设置文件类型        headers.add("Content-Disposition", "attchement;filename=" + file.getName());        //设置Http状态码        HttpStatus statusCode = HttpStatus.OK;        //返回数据        ResponseEntity
    
      entity = new ResponseEntity
     
      (body, headers, statusCode);        return entity;    }
     
    
   

后续补充：

  以上方式实现在开发环境没有任何问题，但是在生产环境会出现无法下载后台报错的情况，原因在于用流的方式读取文件，打成jar包之后，下载的文件会被损坏 ，后来网上说配置pom里面文件路径等等试了没用，直接用了POI的导出

修改后controller：

@RequestMapping(value="/downloadExcel")    public ResponseEntity
   
     excel2007Export(HttpServletResponse response, HttpServletRequest request) {        try {            ClassPathResource cpr = new ClassPathResource("/templates/"+"model.xlsx");            InputStream is = cpr.getInputStream();            Workbook workbook = new XSSFWorkbook(is);            String fileName = "model.xlsx";            downLoadExcel(fileName, response, workbook);        } catch (FileNotFoundException e) {            // TODO Auto-generated catch block            e.printStackTrace();        } catch (IOException e) {            // TODO Auto-generated catch block            e.printStackTrace();        }        return new ResponseEntity
    
     (HttpStatus.OK);    }
    
   

文件工具类downLoadExcel：

public static void downLoadExcel(String fileName, HttpServletResponse response, Workbook workbook) {        try {            response.setCharacterEncoding("UTF-8");            response.setHeader("content-Type", "application/vnd.ms-excel");            response.setHeader("Content-Disposition",                    "attachment;filename=\"" + URLEncoder.encode(fileName, "UTF-8") + "\"");            workbook.write(response.getOutputStream());        } catch (IOException e) {            e.printStackTrace();        }    }

转载地址：http://aawrn.baihongyu.com/