效果图
画斜线代码如下:
ExportParams params = new ExportParams("【" + request.getYearStr() + "】花纹统计明细数据", "数据");
params.setType(ExcelType.HSSF);
Workbook workbook = ExcelExportUtil.exportExcel(params, colList, list);
Sheet sheet = workbook.getSheetAt(0);
Row row = sheet.getRow(1);
Cell cell0 = row.getCell(0);
cell0.setCellValue("花纹 月份");
//画线(由左上到右下的斜线) 在A1的第一个cell(花纹 月份)加入一条对角线
HSSFPatriarch patriarch = (HSSFPatriarch) sheet.createDrawingPatriarch();
HSSFClientAnchor a = new HSSFClientAnchor(0, 0, 1023, 255, (short) 0, 1, (short) 0, 2);
HSSFSimpleShape shape1 = patriarch.createSimpleShape(a);
shape1.setShapeType(HSSFSimpleShape.OBJECT_TYPE_LINE);
shape1.setLineStyle(HSSFSimpleShape.LINESTYLE_SOLID);
核心在于HSSFClientAnchor这个类,不懂的这时候可以百度了,我使用的是EasyPoi的框架,如果你是用ApachePoi直接从WorkBook开始看就行了。