JAVA技巧:poi操作excel-中文與單元格樣式的方法

字號:

package *.*;
    import java.util.ArrayList;
    import java.util.Iterator;
    import org.apache.poi.hssf.usermodel.HSSFCell;
    import org.apache.poi.hssf.usermodel.HSSFCellStyle;
    import org.apache.poi.hssf.usermodel.HSSFFont;
    import org.apache.poi.hssf.usermodel.HSSFRow;
    import org.apache.poi.hssf.usermodel.HSSFSheet;
    import org.apache.poi.hssf.usermodel.HSSFWorkbook;
    public class FontCellStyle {
    private static HSSFFont fontStyle = null;
    private static HSSFCellStyle cellStyle = null;
    /*設(shè)置字體格式*/
    public static HSSFFont getHdrFont(HSSFWorkbook wb) {
    fontStyle = wb.createFont();
    fontStyle.setFontName("微軟雅黑");
    fontStyle.setFontHeightInPoints((short)20);
    fontStyle.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);
    return fontStyle;
    }
    public static HSSFFont getFtrFont(HSSFWorkbook wb) {
    fontStyle = wb.createFont();
    fontStyle.setFontName("微軟雅黑");
    fontStyle.setFontHeightInPoints((short)12);
    fontStyle.setBoldweight(HSSFFont.BOLDWEIGHT_NORMAL);
    return fontStyle;
    }
    public static HSSFFont getContentFont(HSSFWorkbook wb) {
    fontStyle = wb.createFont();
    fontStyle.setFontName("微軟雅黑");
    fontStyle.setFontHeightInPoints((short)12);
    fontStyle.setBoldweight(HSSFFont.BOLDWEIGHT_NORMAL);
    return fontStyle;
    }