From e16302f9d475c7cc4dd18c5abf1a23cb5502e362 Mon Sep 17 00:00:00 2001
From: whyclxw <810412026@qq.com>
Date: 星期三, 28 五月 2025 14:57:56 +0800
Subject: [PATCH] 密码验证加-
---
src/main/java/com/whyc/util/ExcelUtil.java | 21 ++++++++++++++++++---
1 files changed, 18 insertions(+), 3 deletions(-)
diff --git a/src/main/java/com/whyc/util/ExcelUtil.java b/src/main/java/com/whyc/util/ExcelUtil.java
index 5fa4ea0..4ee20b8 100644
--- a/src/main/java/com/whyc/util/ExcelUtil.java
+++ b/src/main/java/com/whyc/util/ExcelUtil.java
@@ -75,11 +75,26 @@
//涓嶄繚瀛樼紦瀛樹俊鎭笌response.reset鍚屾牱鏁堟灉
response.addHeader("Pragma", "no-cache");
response.addHeader("Cache-Control", "no-cache");
- wb.write(os);
- os.flush();
- os.close();
+ if(os!=null){
+ wb.write(os);
+ os.flush();
+ os.close();
+ }
} catch (IOException e) {
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