From b3adf3df8838e36ed3be5e389abda4c3b11220a0 Mon Sep 17 00:00:00 2001
From: whyclxw <http://whyclxw@118.89.139.230:10101/r/~whyclxw/IdeaTest.git>
Date: 星期四, 06 一月 2022 16:44:31 +0800
Subject: [PATCH] 在线监测-实时监控-导出excel
---
src/main/java/com/whyc/util/ExcelUtil.java | 13 +++++++++++++
1 files changed, 13 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/util/ExcelUtil.java b/src/main/java/com/whyc/util/ExcelUtil.java
index 5fa4ea0..ffb5ab0 100644
--- a/src/main/java/com/whyc/util/ExcelUtil.java
+++ b/src/main/java/com/whyc/util/ExcelUtil.java
@@ -82,4 +82,17 @@
e.printStackTrace();
}
}
+
+ //鏋勯�犳寚瀹氱殑鍗曞厓鏍兼牱寮�
+ public static HSSFCellStyle createCellStyle(HSSFWorkbook wb,String fontType,int fontSize,boolean center,boolean blod){
+
+ HSSFCellStyle cellStyle = wb.createCellStyle(); //鍗曞厓鏍兼牱寮�
+ HSSFFont font = wb.createFont();
+ font.setFontName(fontType);
+ font.setFontHeightInPoints((short) fontSize); //璁剧疆瀛椾綋澶у皬
+ font.setBoldweight(blod?HSSFFont.BOLDWEIGHT_BOLD:HSSFFont.BOLDWEIGHT_NORMAL); //绮椾綋鏄剧ず
+ cellStyle.setFont(font); //鏍囬鏍峰紡
+ cellStyle.setAlignment(center?HSSFCellStyle.ALIGN_CENTER_SELECTION:HSSFCellStyle.ALIGN_LEFT); // 灞呬腑
+ return cellStyle;
+ }
}
--
Gitblit v1.9.1