普通字段 ~~~ @Excel(name="姓名",width=25) private java.lang.String name; ~~~ --- 日期字段 ~~~ @Excel(name = "生日", width = 25, format = "yyyy-MM-dd") private Date birthday; ~~~ ---- 图片字段： ~~~ @Excel(name="头像",width=25,type=2) private java.lang.String avatar; ~~~ - excel 单元格存放图片: ![](https://img.kancloud.cn/59/70/597094e12129d3f8bfeca0f3e457b309_768x232.png) - 数据库存放图片相对路径： ![](https://img.kancloud.cn/59/51/59516d940dc6865e49a23175a54a813a_521x95.png) - 列表页面显示小图 ![](https://img.kancloud.cn/c4/bc/c4bc96680f582e0dcfa3757b7065e3f5_1841x261.png) --- 需要字段翻译的 数据库存储的是字典的值，导入导出时显示字典的文本 ~~~ @Excel(name = "性别", width = 25,dicCode="sex") private Integer sex; ~~~ ~~~ @Excel(name="负责部门",width = 25,dictTable ="sys_depart",dicText = "depart_name",dicCode = "id") private String departIds; ~~~