SpringBoot下载resource下的文件(POI)

最新推荐文章于 2024-09-05 15:32:46 发布

芝兰生于深谷

最新推荐文章于 2024-09-05 15:32:46 发布

阅读量1.1k

点赞数 1

本文链接：https://blog.csdn.net/weixin_43612925/article/details/122840151

版权

SpringBoot 专栏收录该内容

17 篇文章 0 订阅

订阅专栏

本文档展示了如何在SpringBoot应用中利用POI库和Hutool工具包下载resource目录下的Excel模板文件。首先，引入了POI和Hutool的相关依赖。然后，定义了一个Controller方法，通过HTTP响应设置字符编码、内容类型和文件名，从类路径读取模板文件并将其写入输出流，实现文件下载。同时，针对不同浏览器，进行了文件名的编码处理，确保正确显示。

摘要由CSDN通过智能技术生成

SpringBoot下载resource下的文件(POI)

1、导入依赖

<dependency>
    <groupId>cn.hutool</groupId>
    <artifactId>hutool-poi</artifactId>
    <version>${hutool.version}</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml</artifactId>
    <version>${poi.version}</version>
</dependency>
<dependency>
    <groupId>org.apache.poi</groupId>
    <artifactId>poi-ooxml-schemas</artifactId>
    <version>${poi.version}</version>
</dependency>

2、编写controller

@ApiOperation(value = "下载默认模板文件", notes = "下载默认模板文件")
@GetMapping(value = "/excel-template/{sort}")
public void downloadHeadTemplate(@PathVariable("sort") String sort) throws Exception {
    HttpServletResponse response = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getResponse();
    response.setCharacterEncoding("UTF-8");
    String fileName = sort+"模板.xlsx";
    String template;
    template = "/excel/reset_default_setting.xlsx";
    response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;charset=utf-8");
    response.setHeader("Content-Disposition", "attachment;filename=" + encodeFileName(fileName));
    try (InputStream inStream = MedalController.class.getResourceAsStream(template);
         OutputStream outputStream = response.getOutputStream()) {

        byte[] b = new byte[1000];
        int len;
        while ((len = inStream.read(b)) > 0) {
            outputStream.write(b, 0, len);
        }
    } catch (IOException e) {
        log.warn("MedalController getExcelTemplate put content failed,cause:{}", e);
    }

}

3、校验浏览器，改变文件名

private String encodeFileName(String fileName) {
    HttpServletRequest request = ((ServletRequestAttributes) RequestContextHolder.getRequestAttributes()).getRequest();
    String codeFileName = null;
    String agent = request.getHeader("User-Agent");
    try {
        if (agent.contains("MSIE") || agent.contains("Trident")) {
            codeFileName = java.net.URLEncoder.encode(fileName, "UTF-8");
        } else {
            // 非IE浏览器的处理：
            codeFileName = new String(fileName.getBytes(StandardCharsets.UTF_8), StandardCharsets.ISO_8859_1);
        }
    } catch (Exception e) {
        e.printStackTrace();
    }
    return codeFileName;
}