Java POI 实现Excel单元格合并及设置字体样式

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;

import org.apache.poi.hssf.util.HSSFColor;

import org.apache.poi.hssf.util.Region;

HSSFWorkbook oWB = new HSSFWorkbook();   --建立工作本

HSSFSheet oSheet = oWB.createSheet();  --建立Sheet

int iRow = 0

HSSFRow oRow = oSheet.createRow((short) iRow); --写入第一行

oSheet.addMergedRegion(new Region((short)0, (short)0, (short)0, (short)9));

--合并单元格（起始行，起始列，结束行，结束列）

                 HSSFFont f  = oWB.createFont();   --设置字体样式

 f.setFontHeightInPoints((short) 16);-- 字号 

 f.setBoldweight(HSSFFont.BOLDWEIGHT_NORMAL);--加粗  

HSSFCellStyle style = oWB.createCellStyle();   

style.setFont(f);  

style.setAlignment(HSSFCellStyle.ALIGN_CENTER);-- 左右居中   

style.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);-- 上下居中   

style.setFillForegroundColor(HSSFColor.ORANGE.index);-- 设置背景色

style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);

setCell(oRow, 0, "第一个单元格",style);  --写入第一列

        public static void setCell(HSSFRow oRow, int iCol, String szValue,HSSFCellStyle oStyle) {

// HSSFCell oCell = oRow.createCell(iCol);

HSSFCell oCell = getCell(oRow, iCol);

oCell.setCellValue(szValue);

oCell.setCellStyle(oStyle);

         }

public static HSSFCell getCell(HSSFRow oRow, int iCol) {

HSSFCell oCell = oRow.getCell(iCol);

if (oCell == null) {

oCell = oRow.createCell(iCol);

}

return oCell;

}