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);