天天看點

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;

}