package com.example.jz.modle.vo; import com.alibaba.excel.annotation.ExcelProperty; import com.alibaba.excel.annotation.write.style.ColumnWidth; import com.alibaba.excel.annotation.write.style.ContentRowHeight; import com.alibaba.excel.annotation.write.style.ContentStyle; import com.alibaba.excel.annotation.write.style.HeadRowHeight; import com.alibaba.excel.enums.BooleanEnum; import com.alibaba.excel.enums.poi.HorizontalAlignmentEnum; import com.alibaba.excel.enums.poi.VerticalAlignmentEnum; import com.alibaba.excel.metadata.data.ImageData; import com.alibaba.excel.metadata.data.WriteCellData; import io.swagger.annotations.ApiModel; import lombok.Data; import java.util.Date; import java.util.List; @Data @ApiModel(description = "导出excel报案材料", value = "ExportExcelReportVo") @ContentRowHeight(120) @HeadRowHeight(20) @ColumnWidth(25) public class ExportExcelReportVo { @ExcelProperty(value = "报案人", index = 0) @ContentStyle(wrapped = BooleanEnum.TRUE, horizontalAlignment = HorizontalAlignmentEnum.CENTER, verticalAlignment = VerticalAlignmentEnum.CENTER) private String realName; @ExcelProperty(value = "手机号码", index = 1) @ContentStyle(wrapped = BooleanEnum.TRUE, horizontalAlignment = HorizontalAlignmentEnum.CENTER, verticalAlignment = VerticalAlignmentEnum.CENTER) private String userMobile; @ExcelProperty(value = "身份证号", index = 2) @ContentStyle(wrapped = BooleanEnum.TRUE, horizontalAlignment = HorizontalAlignmentEnum.CENTER, verticalAlignment = VerticalAlignmentEnum.CENTER) private String userIdcard; //被骗时间 @ExcelProperty(value = "被骗时间", index = 3) @ContentStyle(wrapped = BooleanEnum.TRUE, horizontalAlignment = HorizontalAlignmentEnum.CENTER, verticalAlignment = VerticalAlignmentEnum.CENTER) private Date cheatTime; //涉案金额 @ExcelProperty(value = "涉案金额", index = 4) @ContentStyle(wrapped = BooleanEnum.TRUE, horizontalAlignment = HorizontalAlignmentEnum.CENTER, verticalAlignment = VerticalAlignmentEnum.CENTER) private Double amountInvolved; @ExcelProperty(value = "案件描述",index = 5) @ContentStyle(wrapped = BooleanEnum.TRUE, horizontalAlignment = HorizontalAlignmentEnum.CENTER, verticalAlignment = VerticalAlignmentEnum.CENTER) private String reportDescription; //补充信息 @ExcelProperty(value = "补充信息", index = 6) @ContentStyle(wrapped = BooleanEnum.TRUE, horizontalAlignment = HorizontalAlignmentEnum.CENTER, verticalAlignment = VerticalAlignmentEnum.CENTER) private String information; @ExcelProperty(value = "案件材料", index = 7) @ColumnWidth(120) private WriteCellData> writeCellData; }