From 1024d7a5b86ae091e131bedcc2f5bcf45866fb76 Mon Sep 17 00:00:00 2001
From: whycxzp <glperry@163.com>
Date: 星期三, 30 四月 2025 17:27:19 +0800
Subject: [PATCH] 测试调整格式
---
src/main/java/com/whyc/service/ExcelService.java | 10 ++++++++--
1 files changed, 8 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/whyc/service/ExcelService.java b/src/main/java/com/whyc/service/ExcelService.java
index 0d7eedf..8a130d6 100644
--- a/src/main/java/com/whyc/service/ExcelService.java
+++ b/src/main/java/com/whyc/service/ExcelService.java
@@ -60,9 +60,9 @@
createSheet1(workbook,battGroupId,testRecordCount);
//鍒涘缓sheet2 -- 姣忔湀鐢靛帇,12涓湀,鍙栨瘡鏈�1鍙烽浂鐐归浂鍒�
//鍒涘缓sheet3 -- 姣忔湀鍐呴樆, 12涓湀,鍙栨瘡鏈�1鍙烽浂鐐归浂鍒�
- //createSheet2And3(workbook,battGroupId);
+ createSheet2And3(workbook,battGroupId);
//鍒涘缓sheet4 -- 姣忓ぉ娓╁害, 30澶�, 鍙栨瘡澶╅浂鐐归浂鍒�
- //createSheet4(workbook,battGroupId);
+ createSheet4(workbook,battGroupId);
// 灏嗗伐浣滅翱鍐欏叆鏂囦欢
FileOutputStream fileOut = new FileOutputStream(filePath);
@@ -214,6 +214,10 @@
XSSFCellStyle cellStyleOriginal2 = cellOfSheet3.getCellStyle();
XSSFCellStyle cellStyleNew2 = getCellStyleFont(cellStyleOriginal2,workbook, true, 15);
cellOfSheet3.setCellStyle(cellStyleNew2);
+
+ //璁剧疆鏁板�肩被鍨嬩繚鐣欎綅鏁�
+ setDateFormat(workbook,sheet2,3,110,1,columnCount-2, "0.0000");
+ setDateFormat(workbook,sheet3,3,110,1,columnCount-2, "0.0000");
// 鍒涘缓缁樺浘宸ュ叿
@@ -465,6 +469,8 @@
cell.setCellStyle(cellStyle);
}
+ //璁剧疆鏁板�肩被鍨嬪崟鍏冩牸淇濈暀浣嶆暟
+ setDateFormat(workbook,sheet4,3,110,1,columnCount-2, "0.0000");
createChart(sheet4, columnCount,3,"娓╁害鎶樼嚎鍥�");
}
--
Gitblit v1.9.1