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++;