java 下载excel

最新推荐文章于 2025-06-30 18:17:53 发布

知音难遇

最新推荐文章于 2025-06-30 18:17:53 发布

阅读量166

点赞数

CC 4.0 BY-SA版权

分类专栏： java

本文链接：https://blog.youkuaiyun.com/yzy1970185464/article/details/92832430

java 专栏收录该内容

10 篇文章

订阅专栏

博客展示了前台下载功能的代码实现，通过 `btn_download` 函数调用 `window.open` 打开下载链接。同时提及了后台Controller，但未给出具体代码，主要围绕前后端实现下载功能相关内容。

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

1.前台
function btn_download() {
window.open('/Agvs/Path/Download', '_blank');
}

2.后台Controller

/**
 * 路径下载
 *
 * @param request
 * @param response
 * @throws Exception
 */
@RequestMapping(value = "/Download", method = {RequestMethod.GET})
public void download(HttpServletRequest request, HttpServletResponse response) throws Exception {
    try {
        List<Map<String, Object>> list = pathService.getPathList();
        Map<String, String> headMap = new LinkedHashMap<>();
        headMap.put("PointStart", "起始点编号");
        headMap.put("PointEnd", "结束点编号"); 
        XSSFWorkbook wb = ExcelUtils.exportExcel2(list, headMap, "Path", false);
        response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
        response.setHeader("Content-disposition", "attachment;filename=path.xlsx");
        OutputStream ouputStream = response.getOutputStream();
        wb.write(ouputStream);
        ouputStream.flush();
        ouputStream.close();
    } catch (Exception ex) {
    }
}