POI针对Excel的各种特殊操作

String sheetName = "表名";
HSSFWorkbook hb = new HSSFWorkbook();
HSSFSheet sheet = hb.createSheet(sheetName);

1、合并单元格

CellRangeAddress region = new CellRangeAddress(0, 0, 0, 3); // 开始行，结束行，开始列，结束列
sheet.addMergedRegion(region);  //将单元格添加到sheet中

2、设置单元格格式

HSSFCellStyle contentStyle = hb.createCellStyle();
contentStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);// 水平居中
contentStyle.setVerticalAlignment(CellStyle.VERTICAL_CENTER);// 垂直居中
contentStyle.setWrapText(true);         //自动换行

3、设置单元格颜色

HSSFCellStyle style = hb.createCellStyle();
style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);
style.setFillForegroundColor(HSSFColor.RED.index);  //红色
cell.setCellStyle(style);

4、单元格中添加斜线

HSSFPatriarch patriarch = sheet.createDrawingPatriarch();
HSSFClientAnchor a = new HSSFClientAnchor(0, 0, 1023, 255, (short) 0, 2, (short) 1, 2);
//起点在起点单元格中的具体位置，终点在终点单元格中的具体位置，起点的列，起点的行，终点的列，终点的行
HSSFSimpleShape shape1 = patriarch.createSimpleShape(a);
shape1.setShapeType(HSSFSimpleShape.OBJECT_TYPE_LINE);
shape1.setLineStyle(HSSFSimpleShape.LINESTYLE_SOLID);