poi合并单元格加边框（1）
可以合并的，不过要逐个给每一个被合并的单元格加上边框，这样就ok
?
有木有其他办法? 有木有 ？
?
?
private static void setRegionBorder(int border, CellRangeAddress region, Sheet sheet,Workbook wb){CellStyle cs=wb.createCellStyle();cs.setBorderBottom((short) border);cs.setBorderTop((short) border);cs.setBorderLeft((short) border);cs.setBorderRight((short) border);setRegionStyle( cs, region, sheet);} private static void setRegionStyle(CellStyle cs, CellRangeAddress region, Sheet sheet){ for(int i=region.getFirstRow();i<=region.getLastRow();i++){ Row row=sheet.getRow(i); if(row==null) row=sheet.createRow(i); for(int j=region.getFirstColumn();j<=region.getLastColumn();j++){ Cell cell=row.getCell(j); if( cell==null){ cell=row.createCell(j); cell.setCellValue(""); } cell.setCellStyle(cs); } }}
?
注意1：如果合并在前，则在后面不能直接用
?????? Row row=sheet.createRow(0);
???????? 而应该改为
????? ?Row row=sheet.getRow(0);
???????if(row==null){
? ????????? row2=sheet.createRow(2);
????? ?}
?
??????????否则直接createRow会覆盖先前合并时定义的边框样式。
?
注意2：可以用poi自带的工具类来处理合并后的边框
?????????
?
private static void setRegionBorder(int border, CellRangeAddress region, Sheet sheet,Workbook wb){RegionUtil.setBorderBottom(border,region, sheet, wb);RegionUtil.setBorderLeft(border,region, sheet, wb);RegionUtil.setBorderRight(border,region, sheet, wb);RegionUtil.setBorderTop(border,region, sheet, wb);}?
?
?