hssfrow 单元格样式_【遇到的问题】 POI实现EXCEL单元格合并及边框样式

packagetest;importjava.io.FileOutputStream;importjava.io.IOException;importorg.apache.poi.hssf.usermodel.HSSFCell;importorg.apache.poi.hssf.usermodel.HSSFCellStyle;importorg.apache.poi.hssf.usermodel.HSSFRow;importorg.apache.poi.hssf.usermodel.HSSFSheet;importorg.apache.poi.hssf.usermodel.HSSFWorkbook;importorg.apache.poi.ss.usermodel.BorderStyle;importorg.apache.poi.ss.usermodel.Font;importorg.apache.poi.ss.usermodel.HorizontalAlignment;importorg.apache.poi.ss.util.CellRangeAddress;importorg.apache.poi.ss.util.RegionUtil;public classExcelPoiTest {public static voidmain(String[] args) {

HSSFWorkbook workbook= new HSSFWorkbook(); //创建一个excel//excel生成过程: excel-->sheet-->row-->cell

HSSFSheet sheet = workbook.createSheet("test"); //为excel创建一个名为test的sheet页

HSSFRow row = sheet.createRow(1); //创建一行,参数2表示第一行

HSSFCell cellB2 = row.createCell(1); //在B2位置创建一个单元格

HSSFCell cellB3