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