java:Excel操作（poi）

1.合并单元格

HSSFWorkbook wb=new HSSFWorkbook();
HSSFSheet s1=wb.createSheet();
HSSFRow row=null;
HSSFCell cell=null;
int flag=0;

@SuppressWarnings("deprecation")
CellRangeAddress cra=new CellRangeAddress(flag,flag,0,10);
//起始行  截止行 起始列 截止列
s1.addMergedRegion(cra);
row=s1.createRow(flag);
cell=row.createCell(0);
cell.setCellValue("合并单元格1行,0-10列");
CellStyle style1=wb.createCellStyle();
style1.setAlignment(style1.ALIGN_CENTER);//居中
cell.setCellStyle(style1);
flag++;