正文

POI Excel表格合并,边框设置

IP云
IP云V管理员/25 阅读
11/29
提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示
  1. RegionUtil.setBorderLeft(1, cellRangeAddress, sheet, wb);
  2. RegionUtil.setBorderBottom(1, cellRangeAddress, sheet, wb);
  3. RegionUtil.setBorderRight(1, cellRangeAddress, sheet, wb);
  4. RegionUtil.setBorderTop(1, cellRangeAddress, sheet, wb);
上面是加边框的核心代码,为单元格的上,下左,右四边加边框!我测试在单个合并单元格的时候,是没有什么问题的!但是当我用下面代码的时候会出现有的边框没有
  1. Row row=sheet.createRow((short)0);
  2. ImageUtil.createCell("排序", 0, sctext, row);
  3. CellRangeAddress CellRangeAddress1 = new CellRangeAddress(0,2,0,0);
  4. sheet.addMergedRegion(CellRangeAddress1);
  5. RegionUtil.setBorderLeft(1, cellRangeAddress, sheet, wb);
  6. RegionUtil.setBorderBottom(1, cellRangeAddress, sheet, wb);
  7. RegionUtil.setBorderRight(1, cellRangeAddress, sheet, wb);
  8. RegionUtil.setBorderTop(1, cellRangeAddress, sheet, wb);
  9. ImageUtil.createCell("项目名称", 1, sctext, row);
  10. CellRangeAddress CellRangeAddress2 = new CellRangeAddress(0,2,1,1);
  11. sheet.addMergedRegion(CellRangeAddress2);
  12. ImageUtil.createCell("姓名", 2, sctext, row);
  13. CellRangeAddress CellRangeAddress3 = new CellRangeAddress(0,2,2,2);
  14. sheet.addMergedRegion(CellRangeAddress3);
  15. ImageUtil.createCell("各指标完成情况总数据", 3, sctext, row);
  16. CellRangeAddress CellRangeAddress4 = new CellRangeAddress(0,0,3,8);
  17. sheet.addMergedRegion(new CellRangeAddress(0,0,3,8));
  18. ImageUtil.createCell("各指标完成率", 9, sctext, row);
  19. CellRangeAddress CellRangeAddress5 = new CellRangeAddress(0,0,9,14);
  20. sheet.addMergedRegion(CellRangeAddress5);
  21. Row row2=sheet.createRow((short)1);
  22. ImageUtil.createCell("覆盖面", 3, sctext, row2);
  23. CellRangeAddress CellRangeAddress6 = new CellRangeAddress(1,1,3,4);
  24. sheet.addMergedRegion(CellRangeAddress6);
  25. ImageUtil.createCell("频次", 5, sctext, row2);
  26. CellRangeAddress CellRangeAddress7 = new CellRangeAddress(1,1,5,6);
  27. sheet.addMergedRegion(CellRangeAddress7);

结果如下图:

最后是顺序问题导致的.其原因是因为在编辑单元格的时候,后者覆盖了前者的style.

解决办法:

封装了一个方法:

  1. public void setBorder(CellRangeAddress cellRangeAddress, Sheet sheet,
  2. Workbook wb) throws Exception {
  3. RegionUtil.setBorderLeft(1, cellRangeAddress, sheet, wb);
  4. RegionUtil.setBorderBottom(1, cellRangeAddress, sheet, wb);
  5. RegionUtil.setBorderRight(1, cellRangeAddress, sheet, wb);
  6. RegionUtil.setBorderTop(1, cellRangeAddress, sheet, wb);
  7. }

然后将调用该方法的步骤放到最后,记得是最后,就是全部单元格合并之后,否则会覆盖的,如下:

  1. super.setBorder(CellRangeAddress1, sheet, book);
  2. super.setBorder(CellRangeAddress2, sheet, book);
  3. super.setBorder(CellRangeAddress3, sheet, book);
  4. super.setBorder(CellRangeAddress4, sheet, book);
  5. super.setBorder(CellRangeAddress5, sheet, book);
  6. super.setBorder(CellRangeAddress6, sheet, book);
  7. super.setBorder(CellRangeAddress7, sheet, book);
  8. super.setBorder(CellRangeAddress8, sheet, book);
  9. super.setBorder(CellRangeAddress9, sheet, book);
  10. super.setBorder(CellRangeAddress10, sheet, book);
  11. super.setBorder(CellRangeAddress11, sheet, book);
  12. super.setBorder(CellRangeAddress12, sheet, book);
  13. super.setBorder(CellRangeAddress13, sheet, book);
  14. super.setBorder(CellRangeAddress14, sheet, book);
  15. super.setBorder(CellRangeAddress15, sheet, book);
  16. super.setBorder(CellRangeAddress16, sheet, book);

相关阅读

目录[+]