poi合并单元格加边框（1）

最新推荐文章于 2024-12-11 09:43:07 发布

原创最新推荐文章于 2024-12-11 09:43:07 发布 · 682 阅读

2 ·

CC 4.0 BY-SA版权

文章标签：

#J#

本文介绍了使用POI库为合并的单元格添加边框的方法，包括创建空白单元格和单独设置每个单元格的边框。此外，提供了使用POI自带工具类简化操作的建议。

可以合并的，不过要逐个给每一个被合并的单元格加上边框，这样就ok

有木有其他办法有木有？

poi 文档 FAQ有说明：

12. How do I add a border around a merged cell?

Add blank cells around where the cells normally would have been and set the borders individually for each cell. We will probably enhance HSSF in the future to make this process easier.

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);
	
	}