天天看点

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;

}