easypoi 导入 数字失精_EasyPoi 导入导出Excel时使用GroupName的踩坑解决过程

packagecom.adc.da.customerresourcemanage.dto;importcn.afterturn.easypoi.excel.annotation.Excel;importcom.adc.da.base.entity.BaseEntity;importlombok.Data;importjava.util.Date;

@Datapublic class ContactsDto extendsBaseEntity {/**企业名称-外键 **/@Excel(name= "企业名称",orderNum = "1")privateString enterpriseName;/**姓名 **/@Excel(name= "姓名",orderNum = "2")privateString contactsUsname;/**部门 **/@Excel(name= "部门",orderNum = "3")privateString departName;/**子部门 **/@Excel(name= "子部门",orderNum = "4")privateString childDepartName;/**职务 **/@Excel(name= "职务",orderNum = "5")privateString contactsPost;/**性别 **/@Excel(name= "性别",orderNum = "6")privateString contactsSex;/**手机 **/@Excel(name= "手机",orderNum = "7")privateString contactsPhone;/**座机 **/@Excel(name= "座机",orderNum = "8")privateString contactsLandline;/**邮箱 **/@Excel(name= "邮箱",orderNum = "9")privateString contactsEmail;/**家庭住址 **/@Excel(name= "家庭地址",orderNum = "10")privateString contactsHomeaddress;/**生日 **/@Excel(name= "生日",orderNum = "11",format = "yyyy/MM/dd")privateDate contactsBirthday;/**籍贯 **/@Excel(name= "籍贯",orderNum = "12")privateString contactsBirthplace;/**毕业院校 **/@Excel(name= "毕业院校",orderNum = "13")privateString contactsSchool;/**影响力名称 **/@Excel(name= "影响力",orderNum = "14")privateString effectName;/**亲密度名称 **/@Excel(name= "亲密度",orderNum = "15")privateString intimacyName;/**录入日期 **/@Excel(name= "录入时间",orderNum = "16")privateDate createTime;/**录入人姓名 **/@Excel(name= "录入人",orderNum = "17")privateString createUserName;/**材料 **/@Excel(name= "材料",orderNum = "18",groupName = "客户分类",fixedIndex = 17)privateString stuff;/**评价 **/@Excel(name= "评价",orderNum = "19",groupName = "客户分类",fixedIndex = 18)privateString evaluate;/**市场 **/@Excel(name= "市场",orderNum = "20",groupName = "客户分类",fixedIndex = 19)privateString market;/**法规 **/@Excel(name= "法规",orderNum = "21",groupName = "客户分类",fixedIndex = 20)privateString statute;/**认证**/@Excel(name= "认证",orderNum = "22",groupName = "客户分类",fixedIndex = 21)privateString authentication;/**智能**/@Excel(name= "智能",orderNum = "23",groupName = "客户分类",fixedIndex = 22)privateString intelligence;/**综合**/@Excel(name= "综合",orderNum = "24",groupName = "客户分类",fixedIndex = 23)privateString comprehensive;/**采购 **/@Excel(name= "采购",orderNum = "25",groupName = "客户分类",fixedIndex = 24)privateString purchase;/**财务 **/@Excel(name= "财务",orderNum = "26",groupName = "客户分类",fixedIndex = 25)privateString finance;/**联系人姓名 **/@Excel(name= "联系人姓名",orderNum = "27",fixedIndex = 26)privateString conUsname;/**联系人部门 **/@Excel(name= "联系人部门",orderNum = "28")privateString conDepartName;/**联系人职务 **/@Excel(name= "联系人职务",orderNum = "29")privateString conPost;/**联系方式 **/@Excel(name= "联系方式",orderNum = "30")privateString conPhone;/**联系邮箱 **/@Excel(name= "联系邮箱",orderNum = "31")privateString conEmail;/**备注 **/@Excel(name= "备注",orderNum = "32")privateString remark;

}