方案一:
这个方法能解决:SetEnclosedBorderOfRegion()
//merged cells on mutiple rows
CellRangeAddress region = new CellRangeAddress(2, 4, 0, 0);
sheet.AddMergedRegion(region); //set enclosed border for the merged region ((HSSFSheet)sheet).SetEnclosedBorderOfRegion(region, BorderStyle.DOTTED, NPOI.HSSF.Util.HSSFColor.RED.index);
方案2:
HSSFCellStyle style = wb.createCellStyle(); 创建样式 style.setAlignment(HSSFCellStyle.ALIGN_RIGHT); //字体右对齐 style.setBorderBottom(HSSFCellStyle.BORDER_THIN);//下边框 style.setBorderLeft(HSSFCellStyle.BORDER_THIN);//左边框 style.setBorderTop(HSSFCellStyle.BORDER_THIN);//上边框 style.setBorderRight(HSSFCellStyle.BORDER_THIN);//右边框
HSSFRow row = sheet.createRow(1);
HSSFCell cel = row.createCell(0);
cel.setCellValue(
"
合并单元格");
cel.setCellStyle(style);
for
(
int
j = 1; j <= 11; j++) {
cel = row.createCell(j);
cel.setCellStyle(style);
//style为带边框的样式 上面有定义
cel.setCellValue(
""
);
}