From 0c479f17e5f9ff3ad638f3af783cf22b0a77fbd0 Mon Sep 17 00:00:00 2001
From: 刘小明 <liuxm_a@163.com>
Date: 星期一, 26 八月 2024 16:04:43 +0800
Subject: [PATCH] 排班导出优化
---
pms-parent/pms-web-product/src/main/java/com/dy/pmsProduct/schedule/ExcelVo.java | 51 +++++++++------------------------------------------
1 files changed, 9 insertions(+), 42 deletions(-)
diff --git a/pms-parent/pms-web-product/src/main/java/com/dy/pmsProduct/schedule/ExcelVo.java b/pms-parent/pms-web-product/src/main/java/com/dy/pmsProduct/schedule/ExcelVo.java
index b4f23b8..aac96cc 100644
--- a/pms-parent/pms-web-product/src/main/java/com/dy/pmsProduct/schedule/ExcelVo.java
+++ b/pms-parent/pms-web-product/src/main/java/com/dy/pmsProduct/schedule/ExcelVo.java
@@ -3,21 +3,13 @@
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.*;
import com.alibaba.excel.converters.Converter;
-import com.alibaba.excel.converters.WriteConverterContext;
import com.alibaba.excel.enums.BooleanEnum;
-import com.alibaba.excel.enums.CellDataTypeEnum;
import com.alibaba.excel.enums.poi.BorderStyleEnum;
import com.alibaba.excel.enums.poi.HorizontalAlignmentEnum;
import com.alibaba.excel.enums.poi.VerticalAlignmentEnum;
-import com.alibaba.excel.metadata.GlobalConfiguration;
-import com.alibaba.excel.metadata.data.ImageData;
-import com.alibaba.excel.metadata.data.WriteCellData;
-import com.alibaba.excel.metadata.property.ExcelContentProperty;
import lombok.Data;
-import java.util.ArrayList;
import java.util.Date;
-import java.util.List;
//鍙傝�冿細 https://easyexcel.opensource.alibaba.com/docs/current/quickstart/write
@Data
@@ -27,27 +19,28 @@
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(100) //璁剧疆鍐呭楂樺害
-@ContentFontStyle(fontName="瀹嬩綋", fontHeightInPoints = 14)
+@ContentRowHeight(30) //璁剧疆鍐呭楂樺害
+@ContentFontStyle(fontName="瀹嬩綋", fontHeightInPoints = 11)
@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[]> {
- @ColumnWidth(40)
-// @ContentLoopMerge(eachRow=2)
+ @ColumnWidth(0)//璁剧疆鍒楀涓�0,涓嶆樉绀�
+ @ExcelProperty("ID")
+ public String id ;
+
+ @ColumnWidth(15)
@ExcelProperty("鐢ㄦ埛鍚�")
public String userName ;
- @ColumnWidth(40)
+ @ColumnWidth(20)
@ExcelProperty("鎺掔彮鏃ユ湡")
-// @ContentLoopMerge(eachRow=2)
public String scheduleDate ;
- @ColumnWidth(40)
+ @ColumnWidth(28)
@ExcelProperty("鍒涘缓鏃堕棿")
-// @ContentLoopMerge(eachRow=2)
public Date dt ;
@ColumnWidth(40)
@@ -65,30 +58,4 @@
@ColumnWidth(40)
@ExcelProperty({"鎺掔彮鍐呭","宸ヤ綔鍐呭"})
public String workDetails ;
-
- public WriteCellData<?> convertToExcelData(byte[] value, ExcelContentProperty contentProperty, GlobalConfiguration globalConfiguration) throws Exception {
- WriteCellData cellData = new WriteCellData() ;
- 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;
- }
-
- public WriteCellData<?> convertToExcelData(WriteConverterContext<byte[]> context) throws Exception {
- return this.convertToExcelData(context.getValue(), context.getContentProperty(), context.getWriteContext().currentWriteHolder().globalConfiguration());
- }
-
}
--
Gitblit v1.8.0