1. 模板样式
![在这里插入图片描述](https://i-blog.csdnimg.cn/blog_migrate/df993d25f717d0683887ad5cb6ac11bf.png)
2. class
/**
* 员工信息模板
*/
@Data
public class CompanyStaffExcelDTO {
private static final String GN_FSIAOHF = "社保、公积金、残保金";
private static final String GN_INSURANCE = "商保信息";
@Excel(name = "姓名")
@NotBlank(message = "姓名不能为空")
private String name;
@Excel(name = "身份证号码")
@NotBlank(message = "身份证号码不能为空")
private String idCard;
@Excel(name = "手机号码")
@NotBlank(message = "手机号码不能为空")
private String phone;
@Excel(name = "银行卡号")
@NotBlank(message = "银行卡号不能为空")
private String bankCard;
@Excel(name = "银行名称")
@NotBlank(message = "银行名称不能为空")
private Str