From 34b2fc4c457397cef1f0cc920344c82a9f4a3bc9 Mon Sep 17 00:00:00 2001
From: liurunyu <lry9898@163.com>
Date: 星期二, 15 十月 2024 15:20:07 +0800
Subject: [PATCH] Merge branch 'master' of http://8.140.179.55:20000/r/pipIrr-SV
---
pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/excel/CellWriteHandler.java | 46 +++++++---------------------------------------
1 files changed, 7 insertions(+), 39 deletions(-)
diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/excel/ReportExportCellWriteHandler.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/excel/CellWriteHandler.java
similarity index 68%
rename from pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/excel/ReportExportCellWriteHandler.java
rename to pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/excel/CellWriteHandler.java
index 8f3ede8..f022b96 100644
--- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/excel/ReportExportCellWriteHandler.java
+++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/excel/CellWriteHandler.java
@@ -21,17 +21,16 @@
/**
* @author ZhuBaoMin
- * @date 2024-08-26 14:18
- * @LastEditTime 2024-08-26 14:18
- * @Description
+ * @date 2024-10-12 11:40
+ * @LastEditTime 2024-10-12 11:40
+ * @Description 鎬昏处琛ㄦ牸璁剧疆
*/
-
-public class ReportExportCellWriteHandler extends AbstractVerticalCellStyleStrategy {
+public class CellWriteHandler extends AbstractVerticalCellStyleStrategy {
private String title;
PropertyPlaceholderHelper propertyPlaceholderHelper = new PropertyPlaceholderHelper("${", "}");
- public ReportExportCellWriteHandler(String title) {
+ public CellWriteHandler(String title) {
this.title = title;
}
@@ -110,40 +109,10 @@
if (cell.getRowIndex() >= 2){
((XSSFCellStyle) originCellStyle).setFillForegroundColor(new XSSFColor(new java.awt.Color(237, 237, 237), new DefaultIndexedColorMap()));
- // 绁ㄩ潰鎬讳环
+
//if (cell.getColumnIndex() == 10){
// int actualCellRowNum = context.getCell().getRowIndex() + 1;
// context.getCell().setCellFormula("I" + actualCellRowNum +"+J" + actualCellRowNum);
- // System.out.println("绗�" + context.getCell().getRowIndex() + "琛�,绗�" + context.getCell().getColumnIndex() + "绁ㄩ潰鎬讳环鍐欏叆鍏紡瀹屾垚");
- //}else if (cell.getColumnIndex() == 12){
- // // 鏀粯绁ㄦ
- // int actualCellRowNum = context.getCell().getRowIndex() + 1;
- // context.getCell().setCellFormula("K" + actualCellRowNum +"-L" + actualCellRowNum);
- // System.out.println("绗�" + context.getCell().getRowIndex() + "琛�,绗�" + context.getCell().getColumnIndex() + "鏀粯绁ㄦ鍐欏叆鍏紡瀹屾垚");
- //}else if (cell.getColumnIndex() == 15){
- // // 鏀粯鎬婚
- // int actualCellRowNum = context.getCell().getRowIndex() + 1;
- // context.getCell().setCellFormula("M" + actualCellRowNum +"+N" + actualCellRowNum +"+O" + actualCellRowNum);
- // System.out.println("绗�" + context.getCell().getRowIndex() + "琛�,绗�" + context.getCell().getColumnIndex() + "鏀粯鎬婚鍐欏叆鍏紡瀹屾垚");
- //}else if (cell.getColumnIndex() == 17){
- // // 瀹為檯鍒╂鼎
- // int actualCellRowNum = context.getCell().getRowIndex() + 1;
- // context.getCell().setCellFormula("L" + actualCellRowNum +"+Q" + actualCellRowNum);
- // System.out.println("绗�" + context.getCell().getRowIndex() + "琛�,绗�" + context.getCell().getColumnIndex() + "瀹為檯鍒╂鼎鍐欏叆鍏紡瀹屾垚");
- //}else if (cell.getColumnIndex() == 18){
- // // 搴旀敹娆�
- // int actualCellRowNum = context.getCell().getRowIndex() + 1;
- // context.getCell().setCellFormula("P" + actualCellRowNum +"+R" + actualCellRowNum);
- // System.out.println("绗�" + context.getCell().getRowIndex() + "琛�,绗�" + context.getCell().getColumnIndex() + "搴旀敹娆惧啓鍏ュ叕寮忓畬鎴�");
- //}else if (cell.getColumnIndex() == 20){
- // // 鏈敹娆�
- // int actualCellRowNum = context.getCell().getRowIndex() + 1;
- // context.getCell().setCellFormula("S" + actualCellRowNum +"-T" + actualCellRowNum);
- // System.out.println("绗�" + context.getCell().getRowIndex() + "琛�,绗�" + context.getCell().getColumnIndex() + "鏈敹娆惧啓鍏ュ叕寮忓畬鎴�");
- //}else if (cell.getColumnIndex() >= 2){
- // ((XSSFCellStyle) originCellStyle).setFillForegroundColor(new XSSFColor(new java.awt.Color(189, 215, 238), new DefaultIndexedColorMap()));
- //}else if (cell.getColumnIndex() < 2){
- // ((XSSFCellStyle) originCellStyle).setFillForegroundColor(new XSSFColor(new java.awt.Color(255, 192, 0), new DefaultIndexedColorMap()));
//}
}
@@ -169,5 +138,4 @@
cellData.getWriteCellStyle().setWriteFont(headWriteFont);
}
-}
-
+}
\ No newline at end of file
--
Gitblit v1.8.0