excelStyle

来源：互联网发布：软件前端开发编辑：程序博客网时间：2024/06/05 20:48

package com.chinatopv.util;

import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.HSSFColor;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.Font;

public class ExcelStyle {

   //设置表头样式
   public static HSSFCellStyle getHeadStyle(HSSFWorkbook workbook){
     HSSFCellStyle cellstyle = workbook.createCellStyle();// 设置表头样式
       cellstyle.setAlignment(CellStyle.ALIGN_CENTER);// 设置居中
       HSSFFont headerFont = workbook.createFont(); //创建字体样式
       headerFont.setBoldweight(Font.BOLDWEIGHT_BOLD); // 字体加粗
       headerFont.setFontName("Times New Roman"); //设置字体类型
       headerFont.setFontHeightInPoints((short) 16);
       cellstyle.setFont(headerFont);
       return cellstyle;

}

//设置标题以及内容样式
   public static CellStyle getTitleStyle(HSSFWorkbook workbook){
       CellStyle style = workbook.createCellStyle();
       style.setFillForegroundColor(CellStyle.THIN_BACKWARD_DIAG);
       style.setVerticalAlignment(CellStyle.VERTICAL_CENTER);// 垂直居中
       style.setAlignment(CellStyle.ALIGN_CENTER);

style.setBorderBottom(CellStyle.BORDER_THIN); // 下边框
       style.setBorderLeft(CellStyle.BORDER_THIN);// 左边框
       style.setBorderTop(CellStyle.BORDER_THIN);// 上边框
       style.setBorderRight(CellStyle.BORDER_THIN);// 右边框
       style.setWrapText(true);
       return style;
   }

//设置字体颜色为红色
   public static HSSFFont getFontColor(HSSFWorkbook workbook){
       HSSFFont font = workbook.createFont();
       font.setColor(HSSFColor.RED.index);
       return font;
   }

//调整列宽度
   public static void setWidth(HSSFSheet sheet,int column){
       sheet.autoSizeColumn((short)column);
   }

}

0 0