Excel模板下载

Controller层

@GetMapping("download")
@ApiOperation("下载模板")
public void downLoadFile(@RequestParam String type, HttpServletResponse response) {
    String fileName = "house".equals(type) ? "附件一：xxx.xlsx" : "developer".equals(type) ? "附件二：xxx.xlsx" : "intention".equals(type) ? "附件三：xxx.xlsx":"";
    try {

        WebUtil.downloadFile(response, fileName, "listData/");  //此处listData文件下存放excel模板以供下载
    } catch (IOException e) {
        log.error("[清单管理]", e);
    }
}

WebUtil公用方法

/**
 * @return void
 * @throws
 * @description linux中获取文件路径有问题，建议用此种方法进行下载
 * @Param [response, fileName]
 */
public static void downloadFile(HttpServletResponse response, String fileName, String filePath) throws IOException {
    if (StringUtils.isNotBlank(fileName)) {
        InputStream stream = WebUtil.class.getClassLoader().getResourceAsStream(filePath + fileName);
        @Cleanup BufferedInputStream bis = new BufferedInputStream(stream);
        writeResponse(response, fileName, bis);
    }
}

 

/**
 * @return void
 * @throws
 * @description 向response中写入文件
 * @Param [response, fileName, bis]
 */
private static void writeResponse(HttpServletResponse response, String fileName, BufferedInputStream bis) throws IOException {
    response.setCharacterEncoding("utf-8");
    // 设置强制下载不打开application/force-download
    response.setContentType("application/octet-stream");
    //设置文件名称
    response.addHeader("Content-Disposition", "attachment;fileName=" + URLEncoder.encode(fileName, "utf-8"));
    OutputStream os = response.getOutputStream();
    byte[] buffer = new byte[1024];
    int i = bis.read(buffer);
    while (i != -1) {
        os.write(buffer, 0, i);
        i = bis.read(buffer);
    }
}