From 983e14024d7b1c62b8d4254fc8e654ce206b078b Mon Sep 17 00:00:00 2001 From: lxw <810412026@qq.com> Date: 星期三, 17 五月 2023 16:40:02 +0800 Subject: [PATCH] 文件解析告警数据导出 --- src/main/java/com/whyc/service/ExcelExportService.java | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/src/main/java/com/whyc/service/ExcelExportService.java b/src/main/java/com/whyc/service/ExcelExportService.java index 5143dc3..fefe59e 100644 --- a/src/main/java/com/whyc/service/ExcelExportService.java +++ b/src/main/java/com/whyc/service/ExcelExportService.java @@ -104,7 +104,7 @@ sheet.createRow(rowNumSheet - 1); sheet.getRow(rowNumSheet - 1).createCell(0).setCellValue(picName[i]); //rowNum++; - XSSFClientAnchor anchor = new XSSFClientAnchor(0, 0, 512, 255, (short) 0, rowNumSheet, (short) 10, rowNumSheet + 27); + XSSFClientAnchor anchor = new XSSFClientAnchor(0, 0, 512, 255, (short) 0, rowNumSheet, (short) 10, rowNumSheet + 24); anchor.setAnchorType(ClientAnchor.AnchorType.DONT_MOVE_AND_RESIZE); patriarch.createPicture(anchor, wb.addPicture(bytes.get(picNum), XSSFWorkbook.PICTURE_TYPE_PNG)).resize(1); picNum++; @@ -287,7 +287,7 @@ sheet.createRow(rowNumSheet-1); sheet.getRow(rowNumSheet-1).createCell(0).setCellValue(picName[i]); //rowNum++; - XSSFClientAnchor anchor = new XSSFClientAnchor(0, 0, 512, 255,(short) 0, rowNumSheet, (short) 10, rowNumSheet+27); + XSSFClientAnchor anchor = new XSSFClientAnchor(0, 0, 512, 255,(short) 0, rowNumSheet, (short) 10, rowNumSheet+24); anchor.setAnchorType(ClientAnchor.AnchorType.DONT_MOVE_AND_RESIZE); patriarch.createPicture(anchor,wb.addPicture(bytes.get(picNum),XSSFWorkbook.PICTURE_TYPE_PNG)).resize(1); picNum ++; -- Gitblit v1.9.1