java poi包下载官网,Java技术：easypoi

@ExcelTarget("emp")//相当于给该实体类取一个名字

public class EasyEmployee {

/*

name:列名

width:列宽

*/

@Excel(name="邮箱",width = 25)

private String email;

@Excel(name="用户名")

private String username;

@Excel(name = "年龄")

private Integer age;

/*format:时间格式*/

@Excel(name = "生日",format = "yyyy-MM-dd")

private Date bornDate = new Date();

/* replace:值得替换  导出是{a_id,b_id} 导入反过来 就相当于如果值是true则显示男，如果值为false则显示女*/

@Excel(name="性别",replace = {"男_true","女_false"})

private Boolean sex;

//头像的url地址    savePath:你导入的图片存放的路径(对导入有效) type:导出类型 1 是文本 2 是图片,3 是函数,10 是数字 默认是文本

@Excel(name="头像", type = 2 ,height = 40,width = 30,savePath = "imgs/head")

private String imgUrl;

@ExcelEntity//标记是不是导出excel 标记为实体类,一遍是一个内部属性类,标记是否继续穿透,(简单理解就是我导出关联对象中对应的属性)

private EasyDept dept;

public String getUsername() {

return username;

}

public void setUsername(String username) {

this.username = username;

}

public String getEmail() {

return email;

}

public void setEmail(String email) {

this.email = email;

}

public Integer getAge() {

return age;

}

public void setAge(Integer age) {

this.age = age;

}

public Boolean getSex() {

return sex;

}

public void setSex(Boolean sex) {

this.sex = sex;

}

public Date getBornDate() {

return bornDate;

}

public void setBornDate(Date bornDate) {

this.bornDate = bornDate;

}

public EasyDept getDept() {

return dept;

}

public void setDept(EasyDept dept) {

this.dept = dept;

}

public String getImgUrl() {

return imgUrl;

}

public void setImgUrl(String imgUrl) {

this.imgUrl = imgUrl;

}

}

@ExcelTarget("dept")

public class EasyDept {

/*意思是：如果我导出EasyEmployee的时候一并把关联对象EasyDept导出来，那么我EasyDept中最终导出的名字就为部门

如果我单独只导出EasyDept那我的名字就叫做名字*/

@Excel(name = "部门_emp,名字_dept")

private String name;

@Excel(name = "部门地址_emp,地址_dept")

private String address;

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

}

public String getAddress() {

return address;

}

public void setAddress(String address) {

this.address = address;

}

@Override

public String toString() {

return "EasyDept{" +

"name='" + name + '\'' +

", address='" + address + '\'' +

'}';

}

}