From f1e8ef7d00fc176d5cba60f3f8b8c10a8541bd71 Mon Sep 17 00:00:00 2001 From: zhubaomin <zhubaomin> Date: 星期一, 14 四月 2025 16:07:37 +0800 Subject: [PATCH] 代码优化 --- pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/excel/ExcelUtil.java | 22 ++++++++++++++++++++++ 1 files changed, 22 insertions(+), 0 deletions(-) diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/excel/ExcelUtil.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/excel/ExcelUtil.java new file mode 100644 index 0000000..6674095 --- /dev/null +++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/excel/ExcelUtil.java @@ -0,0 +1,22 @@ +package com.dy.pipIrrGlobal.excel; + +import jakarta.servlet.http.HttpServletResponse; + +import java.io.UnsupportedEncodingException; +import java.net.URLEncoder; + +/** + * @author ZhuBaoMin + * @date 2024-08-26 10:28 + * @LastEditTime 2024-08-26 10:28 + * @Description 璁剧疆excel涓嬭浇鍝嶅簲澶村睘鎬� + */ +public class ExcelUtil { + public static void setExcelRespProp(HttpServletResponse response, String rawFileName) throws UnsupportedEncodingException { + String fileName = URLEncoder.encode(rawFileName, "UTF-8").replaceAll("\\+", "%20"); + response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"); + response.setCharacterEncoding("utf-8"); + response.setHeader("Content-Disposition", "attachment;filename*=utf-8''" + fileName + ".xlsx"); + } + +} -- Gitblit v1.8.0