7.17

luodangjia

2024-08-09 fa672aad1a91b2a8481324339e063230d378039e

 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);
      }