package org.springblade.modules.training.excel; import com.alibaba.excel.annotation.ExcelIgnore; 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.HeadRowHeight; import lombok.Data; import java.io.Serializable; import java.util.Date; /** * TrainingRegistrationExcel * @author zhongrj * @since 2021-12-09 */ @Data @ColumnWidth(25) @HeadRowHeight(20) @ContentRowHeight(18) public class TrainingRegistrationExcel implements Serializable { private static final long serialVersionUID = 1L; @ColumnWidth(15) @ExcelProperty("保安姓名") private String realName; @ColumnWidth(25) @ExcelProperty("考试名称") private String trainExamName; @ColumnWidth(25) @ExcelProperty("所属企业名称") @ExcelIgnore private String deptName; @ColumnWidth(25) @ExcelProperty("从业单位") private String unitName; @ColumnWidth(15) @ExcelProperty("准考证号") private String candidateNo; @ColumnWidth(20) @ExcelProperty("身份证号") private String idCardNo; @ColumnWidth(20) @ExcelProperty("报名时间") private Date trainingTime; @ColumnWidth(20) @ExcelProperty("考试时间") private Date trainExamTime; @ColumnWidth(15) @ExcelProperty("审核状态") private String auditStatus; @ColumnWidth(15) @ExcelProperty("考试状态") private String isExam; }