poi给合并的单元格设置边框

//给合并的单元格设置边框
CellRangeAddress cellRangePlanNo = new CellRangeAddress(1, 1, 1, 3);
sheet.addMergedRegion(cellRangePlanNo);

setBorderForMergeCell(1, cellRangePlanNo, sheet, workBook);

//给一个范围的单元格外面设置边框

//设置最外面四周边框
CellRangeAddress brodercell = new CellRangeAddress(rowIndex-8,rowIndex-1, 0, 7);
setBorderForMergeCell(CellStyle.BORDER_MEDIUM, brodercell, sheet, workBook);

/**
     * 合并单元格设置边框
     * @param i
     * @param cellRangeTitle
     * @param sheet
     * @param workBook
     */
    private static void setBorderForMergeCell(int i, CellRangeAddress cellRangeTitle, Sheet sheet, HSSFWorkbook workBook){
        RegionUtil.setBorderBottom(i, cellRangeTitle, sheet, workBook);
        RegionUtil.setBorderLeft(i, cellRangeTitle, sheet, workBook);
        RegionUtil.setBorderRight(i, cellRangeTitle, sheet, workBook);
        RegionUtil.setBorderTop(i, cellRangeTitle, sheet, workBook);
    }