package com.cn.peitest.excel;
import java.io.File;
import java.lang.reflect.Field;
import java.util.ArrayList;
import java.util.List;
import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
public class ExcelBook {
public static void main(String[] args) {
ArrayList<EmployeeBasicInformation> arrayList=new
ArrayList<EmployeeBasicInformation>(); EmployeeBasicInformation bean0 =new
EmployeeBasicInformation(); bean0.setId("主表id"); bean0.setName("姓名");
bean0.setCreatorCode("用户号"); EmployeeBasicInformation bean =new
EmployeeBasicInformation(); bean.setId("000220"); bean.setName("裴");
bean.setCreatorCode("001223456"); EmployeeBasicInformation bean1 =new
EmployeeBasicInformation(); bean1.setId("000220"); bean1.setName("裴");
bean1.setCreatorCode("001223456"); arrayList.add(bean0); arrayList.add(bean);
arrayList.add(bean1); System.out.println("arrayList============="+arrayList);
excelOut(arrayList);
reflect(bean1);
}
//将数据导出到Excel
public static void excelOut(ArrayList<EmployeeBasicInformation> arrayList) {
WritableWorkbook bWorkbook = null;
try {
// 创建Excel对象
bWorkbook = Workbook.createWorkbook(new File("D:/book.xls"));
// 通过Excel对象创建一个选项卡对象
WritableSheet sheet = bWorkbook.createSheet("sheet1", 0);
//使用循环将数据读出
for (int i =0; i < arrayList.size(); i++) {
EmployeeBasicInformation book=arrayList.get(i);
Label label=new Label(0,i,String.valueOf(book.getId()));
Label label1=new Label(1,i,String.valueOf(book.getName()));
Label label2=new Label(2,i,String.valueOf(book.getCreatorCode()));
sheet.addCell(label);
sheet.addCell(label1);
sheet.addCell(label2);
}
// 创建一个单元格对象，第一个为列，第二个为行，第三个为值
Label label = new Label(0, 2, "test");
// 将创建好的单元格放入选项卡中
//sheet.addCell(label);
// 写如目标路径
bWorkbook.write();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally {
try {
bWorkbook.close();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
//循环获取实体中的值
public static List reflect(EmployeeBasicInformation e){
List list=new ArrayList();
try {
Class cls = e.getClass();
Field[] fields = cls.getDeclaredFields();
for(int i=0; i<fields.length; i++){
Field f = fields[i];
f.setAccessible(true);
System.out.println("属性名:" + f.getName() + " 属性值:" + f.get(e));
list.add(f.get(e));
}
} catch (Exception e2) {
e2.printStackTrace();
// TODO: handle exception
}
return list;
}
}
//实体类
package com.cn.peitest.excel;
import java.io.Serializable;
/**
* 员工基本信息
*
* @author pei
*/
public class EmployeeBasicInformation implements Serializable {
private static final long serialVersionUID = 1L;
/**
* 创建人名称
*/
private String creatorName;
/**
* 创建人编号
*/
private String creatorCode;
/**
* 姓名
*/
private String name;
/**
* 工号
*/
private String employeeNumber;
/**
* 身份证号码
*/
private String idCardNumber;
/**
* 入职日期
*/
private String entryDate;
/**
* 转正日期
*/
private String becomeFullMemberDate;
/**
* 性别
*/
private String sex;
/**
* 部门名称
*/
private String department;
/**
* 部门编号
*/
private String departmentCode;
/**
* 组别
*/
private String group;
/**
* 组编号
*/
private String groupCode;
/**
* 职位
*/
private String position;
/**
* 职能
*/
private String function;
/**
* 职级
*/
private String positionRank;
/**
* 婚否
*/
private String isMarry;
/**
* 合同开始日期
*/
private String contractStartDate;
/**
* 合同结束日期
*/
private String contractEndDate;
/**
* 专业
*/
private String profession;
/**
* 学历
*/
private String educationBackground;
/**
* 政治面貌
*/
private String politicsStatus;
/**
* 毕业院校
*/
private String schoolOfGraduation;
/**
* 户籍地址
*/
private String censusRegisterAddress;
/**
* 户口类型
*/
private String registeredResidenceType;
/**
* 暂住地址
*/
private String temporaryAddress;
/**
* 联系电话
*/
private String contactPhone;
/**
* 紧急联系人
*/
private String emergencyContact;
/**
* 电话
*/
private String phone;
/**
* 在职状态
*/
private String workingState;
/**
* 表id
*/
private String id;
/**
* 租户id
*/
private String tenantId;
/**
* 入职月数
*/
private Double entryMonths;
/**
* 是否删除 0 未删除 1删除
*/
private String isDelete;
public String getCreatorName() {
return creatorName;
}
public void setCreatorName(String creatorName) {
this.creatorName = creatorName;
}
public String getCreatorCode() {
return creatorCode;
}
public void setCreatorCode(String creatorCode) {
this.creatorCode = creatorCode;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getEmployeeNumber() {
return employeeNumber;
}
public void setEmployeeNumber(String employeeNumber) {
this.employeeNumber = employeeNumber;
}
public String getIdCardNumber() {
return idCardNumber;
}
public void setIdCardNumber(String idCardNumber) {
this.idCardNumber = idCardNumber;
}
public String getEntryDate() {
return entryDate;
}
public void setEntryDate(String entryDate) {
this.entryDate = entryDate;
}
public String getBecomeFullMemberDate() {
return becomeFullMemberDate;
}
public void setBecomeFullMemberDate(String becomeFullMemberDate) {
this.becomeFullMemberDate = becomeFullMemberDate;
}
public String getSex() {
return sex;
}
public void setSex(String sex) {
this.sex = sex;
}
public String getDepartment() {
return department;
}
public void setDepartment(String department) {
this.department = department;
}
public String getDepartmentCode() {
return departmentCode;
}
public void setDepartmentCode(String departmentCode) {
this.departmentCode = departmentCode;
}
public String getGroup() {
return group;
}
public void setGroup(String group) {
this.group = group;
}
public String getGroupCode() {
return groupCode;
}
public void setGroupCode(String groupCode) {
this.groupCode = groupCode;
}
public String getPosition() {
return position;
}
public void setPosition(String position) {
this.position = position;
}
public String getFunction() {
return function;
}
public void setFunction(String function) {
this.function = function;
}
public String getPositionRank() {
return positionRank;
}
public void setPositionRank(String positionRank) {
this.positionRank = positionRank;
}
public String getIsMarry() {
return isMarry;
}
public void setIsMarry(String isMarry) {
this.isMarry = isMarry;
}
public String getContractStartDate() {
return contractStartDate;
}
public void setContractStartDate(String contractStartDate) {
this.contractStartDate = contractStartDate;
}
public String getContractEndDate() {
return contractEndDate;
}
public void setContractEndDate(String contractEndDate) {
this.contractEndDate = contractEndDate;
}
public String getProfession() {
return profession;
}
public void setProfession(String profession) {
this.profession = profession;
}
public String getEducationBackground() {
return educationBackground;
}
public void setEducationBackground(String educationBackground) {
this.educationBackground = educationBackground;
}
public String getPoliticsStatus() {
return politicsStatus;
}
public void setPoliticsStatus(String politicsStatus) {
this.politicsStatus = politicsStatus;
}
public String getSchoolOfGraduation() {
return schoolOfGraduation;
}
public void setSchoolOfGraduation(String schoolOfGraduation) {
this.schoolOfGraduation = schoolOfGraduation;
}
public String getCensusRegisterAddress() {
return censusRegisterAddress;
}
public void setCensusRegisterAddress(String censusRegisterAddress) {
this.censusRegisterAddress = censusRegisterAddress;
}
public String getRegisteredResidenceType() {
return registeredResidenceType;
}
public void setRegisteredResidenceType(String registeredResidenceType) {
this.registeredResidenceType = registeredResidenceType;
}
public String getTemporaryAddress() {
return temporaryAddress;
}
public void setTemporaryAddress(String temporaryAddress) {
this.temporaryAddress = temporaryAddress;
}
public String getContactPhone() {
return contactPhone;
}
public void setContactPhone(String contactPhone) {
this.contactPhone = contactPhone;
}
public String getEmergencyContact() {
return emergencyContact;
}
public void setEmergencyContact(String emergencyContact) {
this.emergencyContact = emergencyContact;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
public String getWorkingState() {
return workingState;
}
public void setWorkingState(String workingState) {
this.workingState = workingState;
}
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getTenantId() {
return tenantId;
}
public void setTenantId(String tenantId) {
this.tenantId = tenantId;
}
public Double getEntryMonths() {
return entryMonths;
}
public void setEntryMonths(Double entryMonths) {
this.entryMonths = entryMonths;
}
public String getIsDelete() {
return isDelete;
}
public void setIsDelete(String isDelete) {
this.isDelete = isDelete;
}
public static long getSerialversionuid() {
return serialVersionUID;
}
@Override
public String toString() {
return "EmployeeBasicInformation [creatorName=" + creatorName + ", creatorCode=" + creatorCode + ", name="
+ name + ", employeeNumber=" + employeeNumber + ", idCardNumber=" + idCardNumber + ", entryDate="
+ entryDate + ", becomeFullMemberDate=" + becomeFullMemberDate + ", sex=" + sex + ", department="
+ department + ", departmentCode=" + departmentCode + ", group=" + group + ", groupCode=" + groupCode
+ ", position=" + position + ", function=" + function + ", positionRank=" + positionRank + ", isMarry="
+ isMarry + ", contractStartDate=" + contractStartDate + ", contractEndDate=" + contractEndDate
+ ", profession=" + profession + ", educationBackground=" + educationBackground + ", politicsStatus="
+ politicsStatus + ", schoolOfGraduation=" + schoolOfGraduation + ", censusRegisterAddress="
+ censusRegisterAddress + ", registeredResidenceType=" + registeredResidenceType + ", temporaryAddress="
+ temporaryAddress + ", contactPhone=" + contactPhone + ", emergencyContact=" + emergencyContact
+ ", phone=" + phone + ", workingState=" + workingState + ", id=" + id + ", tenantId=" + tenantId
+ ", entryMonths=" + entryMonths + ", isDelete=" + isDelete + "]";
}
}
