From a2b2529b009e2c410cf8d8f778de068317ffcb1f Mon Sep 17 00:00:00 2001
From: xieb <vip_xiaobin810@163.com>
Date: Thu, 16 May 2024 15:05:30 +0800
Subject: [PATCH] 导出文件名修改
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/word/util/ExcelUtil.java | 4 +++-
1 files changed, 3 insertions(+), 1 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/word/util/ExcelUtil.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/word/util/ExcelUtil.java
index cd0670f..b69e86b 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/word/util/ExcelUtil.java
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztmd/word/util/ExcelUtil.java
@@ -42,7 +42,9 @@
//获取模板(带公式的模板需要文件编辑之后才会显示正常数据)
InputStream inputStream = ExcelUtil.class.getClassLoader().getResourceAsStream("excel/xlsx/totalTemplateNoFormula.xlsx");
- String fileName = StringUtil.format("水库超汛限水位情况计表（{}）.xlsx",tm);
+ String time = new SimpleDateFormat("yyyy-MM-dd HH").format(new Date());
+ String fileName = time+ "时报汛统计.xlsx";
+// String fileName = StringUtil.format("水库超汛限水位情况计表（{}）.xlsx",tm);
ExcelWriter excelWriter = EasyExcel.write(getOutputStream(fileName, response)).withTemplate(inputStream).excelType(ExcelTypeEnum.XLSX).build();
//设置公式生效
// excelWriter.writeContext().writeWorkbookHolder().getWorkbook().setForceFormulaRecalculation(true);
--
Gitblit v1.9.3