From cc839c8d2a0ef8d1311ec327ef0fe9c9eeea6c43 Mon Sep 17 00:00:00 2001
From: jiangping <jp@doumee.com>
Date: 星期一, 29 一月 2024 17:56:14 +0800
Subject: [PATCH] 开发业务接口
---
server/service/src/main/java/com/doumee/core/annotation/excel/ExcelExporter.java | 18 ++++++++++--------
1 files changed, 10 insertions(+), 8 deletions(-)
diff --git a/server/service/src/main/java/com/doumee/core/annotation/excel/ExcelExporter.java b/server/service/src/main/java/com/doumee/core/annotation/excel/ExcelExporter.java
index 6473db7..3526bbe 100644
--- a/server/service/src/main/java/com/doumee/core/annotation/excel/ExcelExporter.java
+++ b/server/service/src/main/java/com/doumee/core/annotation/excel/ExcelExporter.java
@@ -350,6 +350,7 @@
style.setFont(font);
// 璁剧疆杈规
configCellBorder(style);
+// configCellBorder(style);
cell.setCellStyle(style);
}
/**
@@ -478,17 +479,18 @@
sxssfWorkbook = new SXSSFWorkbook();
Sheet sheet = sxssfWorkbook.createSheet(sheetName);
for (int i = 0; i < 6; i++) {
- sheet.setColumnWidth(i, 20 * 2 * 256);
+ sheet.setColumnWidth(i, (i==5?20:15) * 2 * 256);
}
sheet.createFreezePane(0, 1);
- sheet.addMergedRegion(new CellRangeAddress(0 ,0,0,5));
Row title = sheet.createRow(0);
title.setHeight((short) 800);
- Cell c = title.createCell(0);
- c.setCellValue(sheetName);
- configTitleCell(sxssfWorkbook,c);
+ for (int i = 0; i < 6; i++) {
+ title.createCell(i).setCellValue(i==0?sheetName:"");
+ configTitleCell(sxssfWorkbook,title.getCell(i));
+ }
+ sheet.addMergedRegion(new CellRangeAddress(0 ,0,0,5));
Row header1 = sheet.createRow(1);
- header1.setHeight((short) 400);
+ header1.setHeight((short) 500);
header1.createCell(0).setCellValue("鎶曚繚浼佷笟");
header1.createCell(1).setCellValue("淇濋櫓鏂规");
header1.createCell(2).setCellValue("淇濋櫓鐢熸晥璧锋湡");
@@ -515,7 +517,7 @@
header4.createCell(3).setCellValue("韬唤璇佸彿");
header4.createCell(4).setCellValue("娲鹃仯鍗曚綅");
header4.createCell(5).setCellValue("鎵�灞炲伐绉�");
- header4.setHeight((short) 400);
+ header4.setHeight((short) 500);
for (int i = 0; i < 6; i++) {
configFirstCell(sxssfWorkbook,header4.getCell(i));
}
@@ -524,7 +526,7 @@
for (int rowIndex = 0; rowIndex < data.getApplyDetailList().size(); rowIndex++) {
ApplyDetail d = data.getApplyDetailList().get(rowIndex);
Row header5 = sheet.createRow(rowIndex + 4);
- header5.setHeight((short) 300);
+// header5.setHeight((short) 300);
header5.createCell(0).setCellValue(rowIndex+1);
header5.createCell(1).setCellValue(StringUtils.defaultString(d.getMemberName(),""));
header5.createCell(2).setCellValue(Constants.equalsInteger(d.getSex(),0)?"鐢�":(Constants.equalsInteger(d.getSex(),1)?"濂�":"-"));
--
Gitblit v1.9.3