From fa672aad1a91b2a8481324339e063230d378039e Mon Sep 17 00:00:00 2001 From: luodangjia <luodangjia> Date: 星期五, 09 八月 2024 14:56:36 +0800 Subject: [PATCH] 7.17 --- guns-admin/src/main/java/com/stylefeng/guns/modular/system/util/ExcelUtil.java | 6 ++++-- 1 files changed, 4 insertions(+), 2 deletions(-) diff --git a/guns-admin/src/main/java/com/stylefeng/guns/modular/system/util/ExcelUtil.java b/guns-admin/src/main/java/com/stylefeng/guns/modular/system/util/ExcelUtil.java index 4901425..f9fc969 100644 --- a/guns-admin/src/main/java/com/stylefeng/guns/modular/system/util/ExcelUtil.java +++ b/guns-admin/src/main/java/com/stylefeng/guns/modular/system/util/ExcelUtil.java @@ -2,6 +2,8 @@ import org.apache.poi.hssf.usermodel.*; +import org.apache.poi.ss.usermodel.CellType; +import org.apache.poi.ss.usermodel.HorizontalAlignment; import javax.servlet.http.HttpServletResponse; import java.net.URLEncoder; @@ -19,12 +21,12 @@ // 第四步,创建单元格,并设置值表头 设置表头居中 HSSFCellStyle style = wb.createCellStyle(); // 创建一个居中格式 - style.setAlignment((short) 2); + style.setAlignment(HorizontalAlignment.forInt((short) 2)); HSSFCell cell = null; // 创建标题 for (int i = 0; i < title.length; i++) { cell = row.createCell(i); - cell.setCellType(1); + cell.setCellType(CellType.forInt(1)); cell.setCellValue(title[i]); cell.setCellStyle(style); } -- Gitblit v1.7.1