springboot resourse下excel文件的下载

a good idea

已于 2022-03-14 15:44:06 修改

阅读量353

点赞数 1

于 2022-03-14 14:56:13 首次发布

本文链接：https://blog.csdn.net/weixin_40074861/article/details/123478664

版权

工具类同时被 2 个专栏收录

7 篇文章 0 订阅

订阅专栏

poi

1 篇文章 0 订阅

订阅专栏

@RequestMapping("/downloadExcel")
@ResponseBody
public void downloadExampleExcel(HttpServletResponse response) {
    InputStream inputStream = null;
    ServletOutputStream servletOutputStream = null;
    try {
        Resource resource = new DefaultResourceLoader().getResource("classpath:excel.xls");
 
        response.setContentType("application/force-download");
        response.setHeader("Content-Disposition", "attachment;fileName=" + "excel.xls");
 
        inputStream = resource.getInputStream();
        servletOutputStream = response.getOutputStream();
        IOUtils.copy(inputStream, servletOutputStream);
        response.flushBuffer();
    } catch (Exception e) {
        e.printStackTrace();
    } finally {
        try {
            if (servletOutputStream != null) {
                servletOutputStream.close();
                servletOutputStream = null;
            }
            if (inputStream != null) {
                inputStream.close();
                inputStream = null;
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}