import org.apache.poi.ss.util.RegionUtil; //导入依赖的package包/类
/**
 * 获取合并单元格式
 *
 * @param sheet
 * @param row
 * @param columnFrom
 * @param columnTo
 * @return
 */
private static void setRegionBorder(HSSFSheet sheet, int row, int columnFrom, int columnTo) {
    CellRangeAddress region = new CellRangeAddress(row, row, columnFrom, columnTo);
    sheet.addMergedRegion(region);
    final short border = CellStyle.BORDER_THIN;
    HSSFWorkbook wb = sheet.getWorkbook();
    RegionUtil.setBorderBottom(border, region, sheet, wb);
    RegionUtil.setBorderTop(border, region, sheet, wb);
    RegionUtil.setBorderLeft(border, region, sheet, wb);
    RegionUtil.setBorderRight(border, region, sheet, wb);
    RegionUtil.setBottomBorderColor(HSSFColor.BLACK.index, region, sheet, wb);
    RegionUtil.setTopBorderColor(HSSFColor.BLACK.index, region, sheet, wb);
    RegionUtil.setLeftBorderColor(HSSFColor.BLACK.index, region, sheet, wb);
    RegionUtil.setRightBorderColor(HSSFColor.BLACK.index, region, sheet, wb);
}
 

import org.apache.poi.ss.util.RegionUtil; //导入依赖的package包/类
private void setCellRangeAddressBorder(CellRangeAddress rangle, Sheet sheet) {
	int border = 1;
	Workbook wb = sheet.getWorkbook();
	RegionUtil.setBorderBottom(border, rangle, sheet, wb);
	RegionUtil.setBorderLeft(border, rangle, sheet, wb);
	RegionUtil.setBorderRight(border, rangle, sheet, wb);
	RegionUtil.setBorderTop(border, rangle, sheet, wb);
}
 

import org.apache.poi.ss.util.RegionUtil; //导入依赖的package包/类
/**
 * Border 설정.
 * @작성자 : KYJ
 * @작성일 : 2016. 9. 8. 
 * @param region
 * @param sheet
 */
static void border(CellRangeAddress region, Sheet sheet) {
	Workbook wb = sheet.getWorkbook();
	//		sheet.addMergedRegion(region);
	final short borderMediumDashed = CellStyle.BORDER_THIN;
	RegionUtil.setBorderBottom(borderMediumDashed, region, sheet, wb);
	RegionUtil.setBorderTop(borderMediumDashed, region, sheet, wb);
	RegionUtil.setBorderLeft(borderMediumDashed, region, sheet, wb);
	RegionUtil.setBorderRight(borderMediumDashed, region, sheet, wb);
}
 

import org.apache.poi.ss.util.RegionUtil; //导入依赖的package包/类
private void addRegions(XSSFSheet xlsSheet, List<XlsxRegion> regions,  XSSFWorkbook wb ) {
    for (int r = 0, size = regions.size(); r < size; r++) {
        XlsxRegion xlsRegion = regions.get(r);
        CellRangeAddress region = xlsRegion.getCellRangeAddress();
        Border border = xlsRegion.getBorder();
        xlsSheet.addMergedRegion(region);

        try {
         if (border != null) {
             short xlsBottomBorder = getXlsBorderValue(border.getBottom());
             if (xlsBottomBorder > 0) {
                 RegionUtil.setBorderBottom(xlsBottomBorder, region, xlsSheet, wb);
                 RegionUtil.setBottomBorderColor(ExcelColorSupport.getNearestColor(border.getBottomColor()), 
                 		region, xlsSheet, wb);
             }
             short xlsTopBorder = getXlsBorderValue(border.getTop());
             if (xlsTopBorder > 0) {
                 RegionUtil.setBorderTop(xlsTopBorder,region, xlsSheet, wb);
                 RegionUtil.setTopBorderColor(ExcelColorSupport.getNearestColor(border.getTopColor()), 
                 		region, xlsSheet, wb);
             }
             short xlsLeftBorder = getXlsBorderValue(border.getLeft());
             if (xlsLeftBorder > 0) {
                 RegionUtil.setBorderLeft(xlsLeftBorder, region, xlsSheet, wb);
                 RegionUtil.setLeftBorderColor(ExcelColorSupport.getNearestColor(border.getLeftColor()), 
                 		region, xlsSheet, wb);
             }
             short xlsRightBorder = getXlsBorderValue(border.getRight());
             if (xlsRightBorder > 0) {
                 RegionUtil.setBorderRight(xlsRightBorder, region, xlsSheet, wb);
                 RegionUtil.setRightBorderColor(ExcelColorSupport.getNearestColor(border.getRightColor()), 
                 		region, xlsSheet, wb);
             }
         }
        } catch (Throwable t) {
        	// report with subreport and borders crashes in XSSF poi
        	// just log the error and let the report be generated (for now)
        	LOG.error(t.getMessage(), t);            	
        }

    }
    regions.clear();
}