通过代码实例跟我学如何应用Java操作Excel电子表格——在Java程序如何实现对Excel电子表格文件读写的应用实例.docVIP

通过代码实例跟我学如何应用Java操作Excel电子表格——在Java程序如何实现对Excel电子表格文件读写的应用实例 1、新建一个项目poiproject 2、导入poi相应的jar包 3、在edu.jxau.poi.excel中新建实体类VO，类名为UserInfoVo 4、UserInfoVO程序类的代码示例 package edu.jxau.poi.excel; public class UserInfoVO { private String userName ; private String password ; private String trueName ; private String email ; private String phone ; private String addr ; /** * @return the userName */ public String getUserName() { return userName; } /** * @param userName the userName to set */ public void setUserName(String userName) { this.userName = userName; } /** * @return the password */ public String getPassword() { return password; } /** * @param password the password to set */ public void setPassword(String password) { this.password = password; } /** * @return the trueName */ public String getTrueName() { return trueName; } /** * @param trueName the trueName to set */ public void setTrueName(String trueName) { this.trueName = trueName; } /** * @return the email */ public String getEmail() { return email; } /** * @param email the email to set */ public void setEmail(String email) { this.email = email; } /** * @return the phone */ public String getPhone() { return phone; } /** * @param phone the phone to set */ public void setPhone(String phone) { this.phone = phone; } /** * @return the addr */ public String getAddr() { return addr; } /** * @param addr the addr to set */ public void setAddr(String addr) { this.addr = addr; } public UserInfoVO() { } } 5、在edu.jxau.poi.excel中新建对excel文件的写操作WriteExcel.java （1）添加一个WriteExcel.java程序类 （2）WriteExcel类的程序代码示例 package edu.jxau.poi.excel; import java.io.File; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.io.OutputStream; import java.util.ArrayList; import java.util.Iterator; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HS