poi合并单元格加边框(2)
利用org.apache.poi.ss.util.RegionUtil 来处理合并单元格加边框问题
?
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);}?
?
注意:如果合并在前,则在后面不能直接用
?????? Row row=sheet.createRow(0);
???????? 而应该改为
????? ?Row row=sheet.getRow(0);
???????if(row==null){
? ????????? row2=sheet.createRow(2);
????? ?}
?
?????????否则直接createRow会覆盖先前合并时定义的边框样式。造成合并后边框显示不全的问题。
?
?