文件导出至浏览器下载状态的方式

最新推荐文章于 2024-06-03 15:24:34 发布

Gnanx.

最新推荐文章于 2024-06-03 15:24:34 发布

阅读量527

点赞数

分类专栏：项目开发文章标签： java 后端

本文链接：https://blog.csdn.net/qq_49192483/article/details/121516345

版权

项目开发专栏收录该内容

3 篇文章

订阅专栏

本文主要介绍了两种方法将页面表格数据导出为Excel文件：一种不涉及URL直接导出，另一种通过URL实现文件下载。详细探讨了在Java后端如何处理这两种方式的技术实现。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.获取页面表格数据，不涉及URL导出excel

public static void outputExcel(HSSFWorkbook wb, HttpServletResponse response, HttpServletRequest request, String filename){
        OutputStream output;
        try {
            output = response.getOutputStream();
            response.reset();
            String fileName= AttachUtils.encodingFileName(filename+".xls", request);
            if (request.getHeader("User-Agent").toLowerCase().indexOf("firefox") != -1){
                response.addHeader("Content-Disposition", "attachment;filename*=UTF-8''" + fileName);
            }else {
                response.setHeader("Content-Disposition", "attachment; filename=" + fileName);
            }
            response.setContentType("APPLICATION/OCTET-STREAM");
            wb.write(output);
            output.close();

        } catch (IOException e) {
            logger.error("生成excel文件出错"+e);
        }
    }

2.获取页面表格数据，涉及URL

//导出浏览器下载
    @RequestMapping(value = "/download", method = RequestMethod.GET)
    @ResponseBody
    public void download(HttpServletRequest request, HttpServletResponse response) {
        String fileName = ValidateUtils.filter(request.getParameter("fileName"));

//        URL url = this.getClass().getClassLoader().getResource("/template/mergeWord/test.docx");//
        URL url = this.getClass().getClassLoader().getResource("/template/mergeWord/");//
        String filePath = url.getPath() + fileName+".docx";
        responseContentDisposition("test.docx", request, response);
        try (InputStream in = new FileInputStream(filePath)) {
            OutputStream out = response.getOutputStream();

            int b;
            while ((b = in.read()) != -1) {
                out.write(b);
            }
            out.flush();
            out.close();
        } catch (IOException e) {
            logger.info("导出下载失败");
        }
    }