下载excel模板

最新推荐文章于 2024-07-21 22:27:18 发布

唯♧

最新推荐文章于 2024-07-21 22:27:18 发布

阅读量431

点赞数

分类专栏：日常文章标签： java 服务器前端

本文链接：https://blog.csdn.net/qq_37158147/article/details/128408677

版权

日常专栏收录该内容

9 篇文章 0 订阅

订阅专栏

从resource文件目录下面读取所需要下载的文件模板

@GetMapping("/downloadTemplate")
public void downloadTemplate(HttpServletResponse response) {

    ServletOutputStream servletOutputStream = null;
    InputStream inputStream = null;
    try {
        String filename = "文件名.xlsx";
        response.setContentType("application/vnd.ms-excel");
        response.addHeader("Cache-Control", "no-cache, no-store, must-revalidate");
        response.addHeader("charset", "utf-8");
        response.addHeader("Pragma", "no-cache");
        String encodeName = URLEncoder.encode(filename, StandardCharsets.UTF_8.toString());
        response.setHeader("Content-Disposition", "attachment; filename=\"" + encodeName + "\"; filename*=utf-8''" + encodeName);

        inputStream = Thread.currentThread().getContextClassLoader().getResourceAsStream("template/文件名.xlsx");
        servletOutputStream = response.getOutputStream();
        IOUtils.copy(inputStream, servletOutputStream);
        response.flushBuffer();
    } catch (Exception e) {
        e.printStackTrace();
        log.error("下载模板失败"+e.toString());
    } finally {
        try {
            if (servletOutputStream != null) {
                servletOutputStream.close();
            }
            if (inputStream != null) {
                inputStream.close();
            }
        } catch (Exception e) {
            e.printStackTrace();
            log.error("下载模板失败"+e.toString());
        }
    }
}