From fc3ccbfc30b83e432c71c508ef2b9c1052816ed2 Mon Sep 17 00:00:00 2001
From: fei <791364011@qq.com>
Date: 星期日, 11 一月 2026 21:56:34 +0800
Subject: [PATCH] 修改了对应代码
---
ruoyi-common/src/main/java/com/ruoyi/common/utils/poi/ExcelUtilManySheetFour.java | 117 ++++++++++++++++++++++++++++++++++++++++++++--------------
1 files changed, 88 insertions(+), 29 deletions(-)
diff --git a/ruoyi-common/src/main/java/com/ruoyi/common/utils/poi/ExcelUtilManySheetFour.java b/ruoyi-common/src/main/java/com/ruoyi/common/utils/poi/ExcelUtilManySheetFour.java
index 4c5a8de..6d3021f 100644
--- a/ruoyi-common/src/main/java/com/ruoyi/common/utils/poi/ExcelUtilManySheetFour.java
+++ b/ruoyi-common/src/main/java/com/ruoyi/common/utils/poi/ExcelUtilManySheetFour.java
@@ -323,7 +323,7 @@
// 鍏朵粬鎵撳嵃璁剧疆
printSetup.setPaperSize(PrintSetup.A4_PAPERSIZE); // A4绾�
- printSetup.setLandscape(false); // 绾靛悜鎵撳嵃
+ printSetup.setLandscape(true); // 绾靛悜鎵撳嵃
// 鍒涘缓琛屽苟璁剧疆楂樺害
@@ -331,7 +331,7 @@
//鐢熸垚浜岀淮鐮�
if(includeQrCode)
{
- row.setHeight((short)(40 * 40));
+ row.setHeight((short)(55.8 * 20));
Cell cell = row.createCell(6);
// 璁剧疆鍥剧墖澶у皬鍜屼綅缃�
@@ -348,7 +348,7 @@
// anchor.setDy2(255); // 楂樺害
anchor.setAnchorType(ClientAnchor.AnchorType.MOVE_AND_RESIZE);
// 璁＄畻灞呬腑浣嶇疆
- int col1 = 3; // 涓棿鍒�
+ int col1 = 4; // 涓棿鍒�
int col2 = col1 + 3;
anchor.setCol1(col1);
anchor.setCol2(col2);
@@ -377,14 +377,14 @@
row = sheet.createRow(firow);
}
else
- row.setHeight((short)(20 * 20));
+ row.setHeight((short)(33 * 20));
// sheet.addMergedRegion(new CellRangeAddress(1, 1, 0, 7));
if(firow==1)
{
sheet.addMergedRegion(new CellRangeAddress(firow, firow, 0, 8));
// 鍒涘缓琛屽苟璁剧疆楂樺害
- row.setHeight((short)(20 * 20));
+ row.setHeight((short)(33 * 20));
}
Cell titleCell = row.createCell(0);
titleCell.setCellValue("鏂囦欢鏉愭枡绉讳氦鐩綍娓呭崟(鍗峰唴绾�)");
@@ -392,62 +392,86 @@
CellStyle style = wb.createCellStyle();
Font font = wb.createFont();
font.setBold(true);
+ font.setFontHeightInPoints((short) 18);
+
font.setFontName("瀹嬩綋");
style.setFont(font);
+ style.setVerticalAlignment(VerticalAlignment.CENTER);
style.setAlignment(HorizontalAlignment.CENTER);
titleCell.setCellStyle(style);
firow = firow + 1;
row = sheet.createRow(firow);
+
// 灏嗗浐瀹氳楂樻敼涓鸿嚜鍔ㄨ楂橈紝浠ヤ究鍐呭鑳藉畬鏁存樉绀哄湪鍚堝苟鍖哄煙
- row.setHeight((short)(50*20));
+ row.setHeight((short)(27.6*20));
//
CellStyle style1 = wb.createCellStyle();
- style1.setAlignment(HorizontalAlignment.LEFT);
+ style1.setAlignment(HorizontalAlignment.RIGHT);
+ style1.setVerticalAlignment(VerticalAlignment.TOP);
+ Font font1 = wb.createFont();
+ font1.setBold(true);
+ font1.setFontHeightInPoints((short) 12);
+
+ font1.setFontName("瀹嬩綋");
+ style1.setFont(font1);
Cell cell2 = row.createCell(0);
cell2.setCellValue("鍙戞枃鍙�:");
cell2.setCellStyle(style1);
-
+
// 鍚堝苟绗�1-3鍒�
int startCol1 = 1;
- int endCol1 = 3;
+ int endCol1 = 2;
sheet.addMergedRegion(new CellRangeAddress(firow, firow, startCol1, endCol1));
-
+
// 璁剧疆鎵�鏈夊悎骞跺崟鍏冩牸鐨勬牱寮�
for (int col = startCol1; col <= endCol1; col++) {
Cell mergedCell = row.createCell(col);
mergedCell.setCellStyle(style1);
}
-
+
// 鍙湪璧峰鍗曞厓鏍艰缃暟鎹�
+ CellStyle style2 = wb.createCellStyle();
+ style2.setAlignment(HorizontalAlignment.LEFT);
+ style2.setVerticalAlignment(VerticalAlignment.TOP);
+ Font font2 = wb.createFont();
+
+ font2.setFontHeightInPoints((short) 11);
+
+ font2.setFontName("瀹嬩綋");
+ style2.setFont(font2);
Cell inquiryCell = row.getCell(startCol1);
+ inquiryCell.setCellStyle(style2);
inquiryCell.setCellValue(inquiryNumber);
- Cell cell1 = row.createCell(4);
+ Cell cell1 = row.createCell(3);
cell1.setCellValue("妗堝嵎棰樺悕:");
cell1.setCellStyle(style1);
-
+
// 鍒涘缓涓�涓柊鐨勬牱寮忕敤浜庢鍗烽鍚嶅悎骞跺崟鍏冩牸
CellStyle mergedCellStyle = wb.createCellStyle();
mergedCellStyle.cloneStyleFrom(style1); // 缁ф壙鍘熸湁鏍峰紡
mergedCellStyle.setAlignment(HorizontalAlignment.LEFT); // 鏀逛负宸﹀榻�
mergedCellStyle.setWrapText(true); // 鍚敤鑷姩鎹㈣
//mergedCellStyle.setVerticalAlignment(VerticalAlignment.CENTER); // 鍨傜洿灞呬腑
-
+
// 鍚堝苟绗�5-8鍒�
- int startCol = 5;
+ int startCol = 4;
int endCol = 8;
-
+
// 鍏堝垱寤烘墍鏈夐渶瑕佺殑鍗曞厓鏍煎苟璁剧疆鏍峰紡
for (int col = startCol; col <= endCol; col++) {
Cell mergedCell = row.createCell(col);
mergedCell.setCellStyle(mergedCellStyle);
}
-
+
// 鐒跺悗鎵ц鍚堝苟鎿嶄綔
sheet.addMergedRegion(new CellRangeAddress(firow, firow, startCol, endCol));
// 鍙湪璧峰鍗曞厓鏍艰缃暟鎹�
Cell getCas = row.getCell(startCol);
- getCas.setCellStyle(mergedCellStyle);
+
+ style2.setWrapText(true); // 鍚敤鑷姩鎹㈣
+
+ getCas.setCellStyle(style2);
getCas.setCellValue(caseTitle);
// 鍙湪璧峰鍗曞厓鏍艰缃暟鎹�
//ces.setCellValue(caseTitle);
@@ -463,6 +487,11 @@
// row.createCell(0).setCellValue("妗堝嵎棰樺悕:");
firow = firow + 1;
row = sheet.createRow(firow);
+
+
+
+ // 璁剧疆琛ㄥご楂樺害涓�43.2
+ row.setHeight((short)(43.2*20));
System.out.println("++++++++++++++++++++++++++---------++++++++++++");
System.out.println(firow);
column = 0;
@@ -470,6 +499,8 @@
// 鏅�歴heet澶勭悊
// recordId = (DocumentMaterialsVo)list.get(0)
row = sheet.createRow(0);
+ // 璁剧疆琛ㄥご楂樺害涓�43.2
+ row.setHeight((short)(43.2*20));
column = 0;
}
// // 浜х敓涓�琛�
@@ -487,19 +518,46 @@
//鍐欏叆绛惧悕
System.out.println(list.get(0).getDataset().size()+"aaaaaaaaaaaaaaaaaaa0999");
row = sheet.createRow(list.get(0).getDataset().size()+4);
+ row = sheet.createRow(list.get(0).getDataset().size()+5);
+
//
+ CellStyle style4 = wb.createCellStyle();
+
+ Font font4 = wb.createFont();
+ font4.setBold(true);
+ font4.setFontHeightInPoints((short) 12);
+
+ font4.setFontName("瀹嬩綋");
+ style4.setFont(font4);
+
+
int in = 0 ;
- for(int i = 0; i < sigArr.size(); i++) {
- row.createCell(in).setCellValue(sigArr.get(i));
- in = in + 3;
+ for (String s : sigArr) {
+ Cell clr = row.createCell(in);
+
+
+ System.out.println(s);
+ clr.setCellStyle(style4);
+ clr.setCellValue(s);
+
+ in = in + 2;
}
+ System.out.println(in);
+
+ // row = sheet.createRow(0);
+ // row = sheet.createRow(list.get(0).getDataset().size() + 7);
+
//鍐欏叆娉ㄩ噴
for(int i = 0; i < arrAn.size();i++) {
- row = sheet.createRow(list.get(0).getDataset().size() + 5+i);
- int ri = list.get(0).getDataset().size() + 5+i;
+ // System.out.println(arrAn.get(i));
+ row = sheet.createRow(list.get(0).getDataset().size() + 7+i);
+ int ri = list.get(0).getDataset().size() + 7+i;
sheet.addMergedRegion(new CellRangeAddress(ri, ri, 0, 3));
+ if(i==0)
+ row.createCell(0).setCellValue("娉�: "+(i+1)+"銆�"+arrAn.get(i));
+ else
+ row.createCell(0).setCellValue(" "+(i+1)+"銆�"+arrAn.get(i));
- row.createCell(0).setCellValue(i+1+"銆�"+arrAn.get(i));
}
}
@@ -637,7 +695,7 @@
style.setBorderBottom(BorderStyle.THIN);
style.setBottomBorderColor(IndexedColors.GREY_50_PERCENT.getIndex());
Font dataFont = wb.createFont();
- dataFont.setFontName("Arial");
+ dataFont.setFontName("瀹嬩綋");
dataFont.setFontHeightInPoints((short) 10);
style.setFont(dataFont);
styles.put("data", style);
@@ -662,9 +720,9 @@
style.setFillPattern(FillPatternType.SOLID_FOREGROUND);
}*/
Font headerFont = wb.createFont();
- headerFont.setFontName("Arial");
- headerFont.setFontHeightInPoints((short) 10);
- headerFont.setBold(false);
+ headerFont.setFontName("瀹嬩綋");
+ headerFont.setFontHeightInPoints((short) 11);
+ headerFont.setBold(true);
headerFont.setColor(excel.headerColor().index);
style.setFont(headerFont);
headerStyles.put(key, style);
@@ -678,7 +736,7 @@
// 璁剧疆鍗曞厓鏍煎唴瀹硅嚜鍔ㄦ崲琛�
style.setWrapText(true);
Font totalFont = wb.createFont();
- totalFont.setFontName("Arial");
+ totalFont.setFontName("瀹嬩綋");
totalFont.setFontHeightInPoints((short) 10);
style.setFont(totalFont);
styles.put("total", style);
@@ -1163,3 +1221,4 @@
+
--
Gitblit v1.9.1