package com.hr.dto;

import com.yy.basedevelop.common.util.ruoyi.annotation.Excel;
import lombok.Data;
import org.apache.poi.ss.usermodel.IndexedColors;

import java.util.Date;

/**
 * @author yaoy
 * @createTime 2025/10/13 14:11
 **/
@Data
public class DemoExcelDto {

    @Excel(
            name = "名字",
            cellType = Excel.ColumnType.STRING,
            headerColor= IndexedColors.BLUE1
    )
    private String name;

    @Excel(
            name = "名字",
            cellType = Excel.ColumnType.STRING,
            headerColor= IndexedColors.CORAL,
            dictName="test_code"
    )
    private String testCode;
    @Excel(
            name = "日期",
            cellType = Excel.ColumnType.STRING,
            headerColor= IndexedColors.LAVENDER,
            dateFormat = "yyyy-MM-dd HH:mm:ss"
    )
    private Date mydate;

    @Excel(
            name = "性别",
            cellType = Excel.ColumnType.STRING,
            headerColor= IndexedColors.GREY_40_PERCENT,
            dictName = "sex"

    )
    private String sex;
}
