合并单元格代码:
//合并单元格CellRangeAddress cellRangeAddress = new CellRangeAddress(0, 1, 0, 0);sheet.addMergedRegion(cellRangeAddress);//加入边框setBorderStyle(BorderStyle.THIN, cellRangeAddress, sheet);
CellRangeAddress参数说明
前二个参数:第几行到第几行合并
后二个参数:第几列到第几列合并
合并后加入边框代码:
/*** 合并单元格设置边框* @param* @param cellRangeTitle* @param sheet*/private void setBorderStyle(BorderStyle borderStyle, CellRangeAddress cellRangeTitle, Sheet sheet){RegionUtil.setBorderBottom(borderStyle, cellRangeTitle, sheet);//下边框RegionUtil.setBorderLeft(borderStyle, cellRangeTitle, sheet);//左边框RegionUtil.setBorderRight(borderStyle, cellRangeTitle, sheet);//右边框RegionUtil.setBorderTop(borderStyle, cellRangeTitle, sheet);//上边框}