From 7666113e060747cce6be99e0deb68485b4283161 Mon Sep 17 00:00:00 2001
From: rk <94314517@qq.com>
Date: 星期一, 20 十月 2025 10:38:41 +0800
Subject: [PATCH] 钥匙柜 电信大屏 配置文件
---
server/system_service/src/main/java/com/doumee/core/annotation/excel/ExcelExporter.java | 22 ++++++++++++++--------
1 files changed, 14 insertions(+), 8 deletions(-)
diff --git a/server/system_service/src/main/java/com/doumee/core/annotation/excel/ExcelExporter.java b/server/system_service/src/main/java/com/doumee/core/annotation/excel/ExcelExporter.java
index 5408db0..05624af 100644
--- a/server/system_service/src/main/java/com/doumee/core/annotation/excel/ExcelExporter.java
+++ b/server/system_service/src/main/java/com/doumee/core/annotation/excel/ExcelExporter.java
@@ -448,10 +448,16 @@
for (int j = 0; j < rowList.size(); j++) {
Cell cell = row.createCell(j);
cell.setCellValue(rowList.get(j));
- if(i ==0 || j==0){
- // 鍒楀璁剧疆
- sheet.setColumnWidth(i, rowList.get(i).length() * 2 * 256);
- // 璁剧疆鍒楀ご鍗曞厓鏍�
+// if(i==0&&j==0){
+// cell.setCellValue("鏁版嵁鏃ユ湡");
+// }else{
+// cell.setCellValue(rowList.get(j));
+// }
+ if(i==0){
+ sheet.setColumnWidth(i, (rowList.get(j).length() + 2 ) * 2 * 256);
+// cell.setCellStyle(hstyle);
+ }
+ if(i==0 || j==0){
cell.setCellStyle(hstyle);
}else{
cell.setCellStyle(rowStyle);
@@ -473,6 +479,7 @@
}
}
+
private static CellStyle configHeaderCellStatic (SXSSFWorkbook workbook) {
CellStyle style = workbook.createCellStyle();
style.setAlignment(HorizontalAlignment.CENTER);
@@ -482,7 +489,7 @@
style.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex());
// 瀛椾綋
Font font = workbook.createFont();
- font.setFontHeightInPoints((short) 12);
+ font.setFontHeightInPoints((short) 10);
style.setFont(font);
// 璁剧疆杈规
configCellBorder(style);
@@ -498,8 +505,8 @@
configDataCellStyle.setAlignment(HorizontalAlignment.CENTER);
configDataCellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
// 璁剧疆鑳屾櫙
- configDataCellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
- configDataCellStyle.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex());
+// configDataCellStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
+// configDataCellStyle.setFillForegroundColor(IndexedColors.GREY_25_PERCENT.getIndex());
// 瀛椾綋
Font font = workbook.createFont();
font.setFontHeightInPoints((short) 10);
@@ -508,7 +515,6 @@
// 杈规
configCellBorder(configDataCellStyle);
configDataCellStyle.setWrapText(true);
-
return configDataCellStyle;
}
--
Gitblit v1.9.3