first commit

perryhsu

2020-09-30 3ab47f8fdd1da2c97917c38b2510855d7c3963c4

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
package com.fgkj.servlets;
 
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFFont;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
 
public class ExcelUtil {
 
    //构造指定的单元格样式
    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;
    }
    
    
}