From 0ad8e58952b396bd689433a0b29e4a66f9bc0817 Mon Sep 17 00:00:00 2001
From: liurunyu <lry9898@163.com>
Date: 星期四, 22 五月 2025 17:33:39 +0800
Subject: [PATCH] 导出用户信息，主要导出用户二维码
---
pms-parent/pms-web-base/src/main/java/com/dy/pmsBase/MarkQrCode/ExcelVo.java | 64 +++++++++++++++++++++-----------
1 files changed, 42 insertions(+), 22 deletions(-)
diff --git a/pms-parent/pms-web-base/src/main/java/com/dy/pmsBase/MarkQrCode/ExcelVo.java b/pms-parent/pms-web-base/src/main/java/com/dy/pmsBase/MarkQrCode/ExcelVo.java
index 8baac6b..2ceee78 100644
--- a/pms-parent/pms-web-base/src/main/java/com/dy/pmsBase/MarkQrCode/ExcelVo.java
+++ b/pms-parent/pms-web-base/src/main/java/com/dy/pmsBase/MarkQrCode/ExcelVo.java
@@ -20,20 +20,35 @@
//鍙傝�冿細 https://easyexcel.opensource.alibaba.com/docs/current/quickstart/write
@Data
-@HeadRowHeight(40) //璁剧疆鏍囬楂樺害
+@HeadRowHeight(40) //璁剧疆鏍囬楂樺害
@HeadFontStyle(fontName="瀹嬩綋", fontHeightInPoints = 16)
-@HeadStyle(wrapped = BooleanEnum.TRUE, shrinkToFit = BooleanEnum.TRUE,
- horizontalAlignment = HorizontalAlignmentEnum.CENTER, verticalAlignment = VerticalAlignmentEnum.CENTER,
- borderLeft = BorderStyleEnum.THIN, borderRight = BorderStyleEnum.THIN, borderTop = BorderStyleEnum.THIN, borderBottom = BorderStyleEnum.THIN,
- leftBorderColor = 8, rightBorderColor = 8, topBorderColor = 8, bottomBorderColor = 8) //IndexedColors.BLACK
+@HeadStyle(wrapped = BooleanEnum.TRUE,
+ shrinkToFit = BooleanEnum.TRUE,
+ horizontalAlignment = HorizontalAlignmentEnum.CENTER,
+ verticalAlignment = VerticalAlignmentEnum.CENTER,
+ borderLeft = BorderStyleEnum.THIN,
+ borderRight = BorderStyleEnum.THIN,
+ borderTop = BorderStyleEnum.THIN,
+ borderBottom = BorderStyleEnum.THIN,
+ leftBorderColor = 8,
+ rightBorderColor = 8,
+ topBorderColor = 8,
+ bottomBorderColor = 8) //IndexedColors.BLACK
@ContentRowHeight(220) //璁剧疆鍐呭楂樺害
@ContentFontStyle(fontName="瀹嬩綋", fontHeightInPoints = 14)
-@ContentStyle(wrapped = BooleanEnum.TRUE, shrinkToFit = BooleanEnum.TRUE,
- horizontalAlignment = HorizontalAlignmentEnum.CENTER, verticalAlignment = VerticalAlignmentEnum.CENTER,
- borderLeft = BorderStyleEnum.THIN, borderRight = BorderStyleEnum.THIN, borderTop = BorderStyleEnum.THIN, borderBottom = BorderStyleEnum.THIN,
- leftBorderColor = 8, rightBorderColor = 8, topBorderColor = 8, bottomBorderColor = 8) //IndexedColors.BLACK
-
-@ColumnWidth(16) //璁剧疆鍒楀
+@ContentStyle(wrapped = BooleanEnum.TRUE,
+ shrinkToFit = BooleanEnum.TRUE,
+ horizontalAlignment = HorizontalAlignmentEnum.CENTER,
+ verticalAlignment = VerticalAlignmentEnum.CENTER,
+ borderLeft = BorderStyleEnum.THIN,
+ borderRight = BorderStyleEnum.THIN,
+ borderTop = BorderStyleEnum.THIN,
+ borderBottom = BorderStyleEnum.THIN,
+ leftBorderColor = 8,
+ rightBorderColor = 8,
+ topBorderColor = 8,
+ bottomBorderColor = 8) //IndexedColors.BLACK
+@ColumnWidth(16) //璁剧疆鍒楀
public class ExcelVo implements Converter<byte[]> {
@ExcelProperty("缂栫爜")
public String code ; //缂栫爜
@@ -45,17 +60,22 @@
public WriteCellData<?> convertToExcelData(byte[] value, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) throws Exception {
WriteCellData cellData = new WriteCellData() ;
- List<ImageData> list = new ArrayList<>();
- ImageData imd = new ImageData();
- imd.setImage(value);
- imd.setImageType(ImageData.ImageType.PICTURE_TYPE_PICT);
- imd.setLeft(10);
- imd.setTop(10);
- imd.setRight(10);
- imd.setBottom(10);
- list.add(imd) ;
- cellData.setImageDataList(list);
- cellData.setType(CellDataTypeEnum.EMPTY);
+ if(value != null && value.length >0){
+ List<ImageData> list = new ArrayList<>();
+ ImageData imd = new ImageData();
+ imd.setImage(value);
+ imd.setImageType(ImageData.ImageType.PICTURE_TYPE_PICT);
+ imd.setLeft(10);
+ imd.setTop(10);
+ imd.setRight(10);
+ imd.setBottom(10);
+ list.add(imd) ;
+ cellData.setImageDataList(list);
+ cellData.setType(CellDataTypeEnum.EMPTY);
+ }else{
+ cellData.setStringValue("");
+ cellData.setType(CellDataTypeEnum.STRING);
+ }
return cellData;
}
--
Gitblit v1.8.0