From fbd31387721424c65b173cbb23b03202f3e7dce6 Mon Sep 17 00:00:00 2001
From: zhoushihao <zsh19950802@163.com>
Date: 星期一, 12 五月 2025 21:13:47 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'
---
hangzhoumesParent/common/servicebase/src/main/java/com/mes/utils/excel/CustomCellStyleHandler.java | 35 +++++++++++++++++++++++++++++++++++
1 files changed, 35 insertions(+), 0 deletions(-)
diff --git a/hangzhoumesParent/common/servicebase/src/main/java/com/mes/utils/excel/CustomCellStyleHandler.java b/hangzhoumesParent/common/servicebase/src/main/java/com/mes/utils/excel/CustomCellStyleHandler.java
new file mode 100644
index 0000000..227f445
--- /dev/null
+++ b/hangzhoumesParent/common/servicebase/src/main/java/com/mes/utils/excel/CustomCellStyleHandler.java
@@ -0,0 +1,35 @@
+package com.mes.utils.excel;
+
+import com.alibaba.excel.write.handler.CellWriteHandler;
+import com.alibaba.excel.write.handler.context.CellWriteHandlerContext;
+import org.apache.poi.ss.usermodel.*;
+import org.apache.poi.xssf.usermodel.XSSFFont;
+
+/**
+ * @Author : zhoush
+ * @Date: 2025/5/12 20:32
+ * @Description:
+ */
+public class CustomCellStyleHandler implements CellWriteHandler {
+
+ @Override
+ public void afterCellDispose(CellWriteHandlerContext context) {
+ // 鑾峰彇鍗曞厓鏍�
+ Cell cell = context.getCell();
+ CellStyle cellStyle = cell.getCellStyle();
+
+ // 璁剧疆姘村钩鍜屽瀭鐩村眳涓�
+ cellStyle.setAlignment(HorizontalAlignment.CENTER);
+ cellStyle.setVerticalAlignment(VerticalAlignment.CENTER);
+
+ cellStyle.setFont(new XSSFFont());
+
+ cellStyle.setBorderBottom(BorderStyle.THIN);
+ cellStyle.setBorderLeft(BorderStyle.THIN);
+ cellStyle.setBorderRight(BorderStyle.THIN);
+ cellStyle.setBorderTop(BorderStyle.THIN);
+
+ // 璁剧疆鏍峰紡鍥炲埌鍗曞厓鏍�
+ cell.setCellStyle(cellStyle);
+ }
+}
--
Gitblit v1.8.0