HSSFWorkBook合并单元格设置边框

private static void setRegionStyle(CellRangeAddress region, HSSFSheet sheet, HSSFWorkbook workbook) {
		HSSFCellStyle headerStyle = getCellStyle(workbook, true, HSSFColor.LIGHT_GREEN.index);
		for (int i = region.getFirstRow(); i <= region.getLastRow(); i++) {
			HSSFRow row = sheet.getRow(i);
			if (row == null) {
				row = sheet.createRow(i);
			}
			for (int j = region.getFirstColumn(); j <= region.getLastColumn(); j++) {
				HSSFCell cell = row.getCell(j);
				if (cell == null) {
					cell = row.createCell(j);
					cell.setCellValue("");
				}
				cell.setCellStyle(headerStyle);
			}
		}
	}

 

转载于:https://my.oschina.net/zhangdq/blog/1860165