jxl读取Excel文件，dom4j写入xml文件例子

1.创建类对象

public class Mobile {
private String sendDate;//发货日期
private String area;//所属区域
private String project;//项目名称
private String number;//中奖号码
private String pType;//奖项
private String pName;//奖品名称
private String city;//属地
private String brand;//品牌
private String name;//姓名
private String post;//邮政编码
private String address;//配送地址
private String mobile;//联系电话
private String code;//邮件号码

public String getSendDate() {
return sendDate;
}
public void setSendDate(String sendDate) {
this.sendDate = sendDate;
}
public String getArea() {
return area;
}
public void setArea(String area) {
this.area = area;
}
public String getProject() {
return project;
}
public void setProject(String project) {
this.project = project;
}
public String getNumber() {
return number;
}
public void setNumber(String number) {
this.number = number;
}
public String getpType() {
return pType;
}
public void setpType(String pType) {
this.pType = pType;
}
public String getpName() {
return pName;
}
public void setpName(String pName) {
this.pName = pName;
}
public String getCity() {
return city;
}
public void setCity(String city) {
this.city = city;
}
public String getBrand() {
return brand;
}
public void setBrand(String brand) {
this.brand = brand;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPost() {
return post;
}
public void setPost(String post) {
this.post = post;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getMobile() {
return mobile;
}
public void setMobile(String mobile) {
this.mobile = mobile;
}
public String getCode() {
return code;
}
public void setCode(String code) {
this.code = code;
}

}

2.创建执行类

public class MobileDao {

public static void main(String[] args) {
MobileDao mobileDao = new MobileDao();
List<Mobile> mobile_list = new ArrayList<Mobile>();
mobile_list = mobileDao.readerExcels("/mobile.xls");
System.out.println("读写xml结果："+mobileDao.writeXML(mobile_list));

}

/**
* 读取Excel
* @return
*/
public List<Mobile> readerExcels(String url){
InputStream is = null;
List<Mobile> Mobile_list = new ArrayList<Mobile>();
try {
is = this.getClass().getResourceAsStream(url);
Workbook workBook = Workbook.getWorkbook(is);
Sheet sheet = workBook.getSheet(0);
for(int i = 0 ; i < sheet.getRows() ; i ++){
Cell[] cell = sheet.getRow(i);
String content = cell[0].getContents();
if(content == "" || content == null){
break;
}
Mobile mobile = new Mobile();
mobile.setSendDate(cell[0].getContents());
mobile.setArea(cell[1].getContents());
mobile.setProject(cell[2].getContents());
mobile.setNumber(cell[3].getContents());
mobile.setpType(cell[4].getContents());
mobile.setpName(cell[5].getContents());
mobile.setCity(cell[6].getContents());
mobile.setBrand(cell[7].getContents());
mobile.setName(cell[8].getContents());
mobile.setPost(cell[9].getContents());
mobile.setAddress(cell[10].getContents());
mobile.setMobile(cell[11].getContents());
mobile.setCode(cell[12].getContents());
Mobile_list.add(mobile);
}
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
is.close();
} catch (Exception e) {
e.printStackTrace();
}
}
return Mobile_list;
}
//把数据写入xml
public boolean writeXML(List<Mobile> mobile_list){
OutputStream os = null;
XMLWriter write = null;
boolean flag = false;
try {
os = new FileOutputStream("src/mobile.xml");
Document doument = DocumentHelper.createDocument();
Element root = doument.addElement("mobiles");
for(Mobile mobile : mobile_list){
Element user = root.addElement("user");
user.addElement("sendDate").setText(mobile.getSendDate() == "" || mobile.getSendDate() == null ? "无":mobile.getSendDate());
user.addElement("area").setText(mobile.getArea() == "" || mobile.getArea() == null ? "无" :mobile.getArea());
user.addElement("project").setText(mobile.getProject() == "" || mobile.getProject() == null ? "无" : mobile.getProject());
user.addElement("number").setText(mobile.getNumber() == "" || mobile.getNumber() == null ? "无" : mobile.getNumber());
user.addElement("pType").setText(mobile.getpType() == "" || mobile.getpType() == null ? "无" : mobile.getpType());
user.addElement("pName").setText(mobile.getpName() == "" || mobile.getpName() == null ? "无" : mobile.getpName());
user.addElement("city").setText(mobile.getCity() == "" || mobile.getCity() == null ? "无" : mobile.getCity());
user.addElement("brand").setText(mobile.getBrand() == "" || mobile.getBrand() == null ? "无" : mobile.getBrand());
user.addElement("name").setText(mobile.getName() == "" || mobile.getName() == null ? "无" : mobile.getName());
user.addElement("post").setText(mobile.getPost() == "" || mobile.getPost() == null ? "无" : mobile.getPost());
user.addElement("address").setText(mobile.getAddress() == "" || mobile.getAddress() == null ? "无" : mobile.getAddress());
user.addElement("mobile").setText(mobile.getMobile() == "" || mobile.getMobile() == null ? "无" : mobile.getMobile());
user.addElement("code").setText(mobile.getCode() == "" || mobile.getCode() == null ? "无" : mobile.getCode());
}
OutputFormat of = OutputFormat.createPrettyPrint();
write = new XMLWriter(os, of);
write.write(doument);
return flag = true;
} catch (Exception e) {
e.printStackTrace();
return flag;
} finally {
try {
os.close();
write.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}
}