基于hutool的excel模板下载

csncn21

已于 2022-11-08 10:38:09 修改

阅读量652

点赞数 1

分类专栏： spring 文章标签： spring

于 2022-07-05 18:09:32 首次发布

本文链接：https://blog.csdn.net/u014007760/article/details/125625219

版权

spring 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

        ExcelWriter excelWriter = null;
        try {
            HttpServletResponse response =
                    ServletRequestAttributes.class.cast(RequestContextHolder.getRequestAttributes()).getResponse();
            response.setContentType("application/vnd.ms-excel;charset=utf-8");
            response.setHeader("Content-disposition", "attachment; filename=" + URLEncoder.encode("示例导出"+"-"+ DateUtil.today()+".xlsx", "utf-8"));
            excelWriter = ExcelUtil.getReader(new ClassPathResource(“template/demo.xlsx”).getInputStream())
                    .getWriter();
            excelWriter.flush(response.getOutputStream(),true);
        } catch (IOException e) {
            throw new RuntimeException(e);
        }finally {
            excelWriter.close();
        }