From 2ad706fd9005392d063122b74d7560a2369b20c8 Mon Sep 17 00:00:00 2001
From: 陈昶聿 <chychen@nbjetron.com>
Date: 星期二, 16 十二月 2025 14:56:53 +0800
Subject: [PATCH] 【丽水】随访统计导出 导出的文件名应为 X月出院随访统计
---
ruoyi-common/src/main/java/com/ruoyi/common/utils/poi/ExcelUtil.java | 28 +++++++++++++++++++++++-----
1 files changed, 23 insertions(+), 5 deletions(-)
diff --git a/ruoyi-common/src/main/java/com/ruoyi/common/utils/poi/ExcelUtil.java b/ruoyi-common/src/main/java/com/ruoyi/common/utils/poi/ExcelUtil.java
index b37fc98..218c782 100644
--- a/ruoyi-common/src/main/java/com/ruoyi/common/utils/poi/ExcelUtil.java
+++ b/ruoyi-common/src/main/java/com/ruoyi/common/utils/poi/ExcelUtil.java
@@ -1,14 +1,11 @@
package com.ruoyi.common.utils.poi;
-import java.io.File;
-import java.io.FileOutputStream;
-import java.io.IOException;
-import java.io.InputStream;
-import java.io.OutputStream;
+import java.io.*;
import java.lang.reflect.Field;
import java.lang.reflect.Method;
import java.lang.reflect.ParameterizedType;
import java.math.BigDecimal;
+import java.net.URLEncoder;
import java.text.DecimalFormat;
import java.time.LocalDate;
import java.time.LocalDateTime;
@@ -448,6 +445,27 @@
}
/**
+ * 瀵筶ist鏁版嵁婧愬皢鍏堕噷闈㈢殑鏁版嵁瀵煎叆鍒癳xcel琛ㄥ崟锛堝甫鏂囦欢鍚嶏級
+ *
+ * @param response 杩斿洖鏁版嵁
+ * @param list 瀵煎嚭鏁版嵁闆嗗悎
+ * @param sheetName 宸ヤ綔琛ㄧ殑鍚嶇О
+ * @param fileName 瀵煎嚭鏂囦欢鐨勫悕绉�
+ * @return 缁撴灉
+ */
+ public void exportExcelWithFileName(HttpServletResponse response, List<T> list, String sheetName, String fileName) {
+ //璁剧疆鏂囦欢鍚�
+ try {
+ fileName = URLEncoder.encode(fileName, "UTF8") + ".xls";
+ response.setHeader("Content-Disposition",
+ "attachment;filename=" + fileName);
+ } catch (UnsupportedEncodingException e) {
+ throw new RuntimeException(e);
+ }
+ exportExcel(response, list, sheetName, StringUtils.EMPTY);
+ }
+
+ /**
* 瀵筶ist鏁版嵁婧愬皢鍏堕噷闈㈢殑鏁版嵁瀵煎叆鍒癳xcel琛ㄥ崟
*
* @param sheetName 宸ヤ綔琛ㄧ殑鍚嶇О
--
Gitblit v1.9.3