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会覆盖先前合并时定义的边框样式。造成合并后边框显示不全的问题。