POI-读取Excel文件

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.poi.pojo.User;

public class ExcelToPoi {
    public static void main(String[] args) throws FileNotFoundException, IOException {
        long currentTimeMillis = System.currentTimeMillis();
        List<User> arrayList = new ArrayList<User>();
        int id = 0;
        String name = null;
        int age = 0;
        String sex = null;
        long phoneNum = 0L;
        String homeAddress = null;
        String companyAddress = null;
        HSSFWorkbook hssfWorkbook = new HSSFWorkbook(new FileInputStream(new File("F:\students.xls")));
        for (int q = 0; q < 8; q++) {
            HSSFSheet sheetAt = hssfWorkbook.getSheetAt(q);
            int firstRowNum = sheetAt.getFirstRowNum() + 1;// 开始行号
            int lastRowNum = sheetAt.getLastRowNum();// 结束行号
            for (int i = firstRowNum; i <= lastRowNum; i++) {
                HSSFRow row = sheetAt.getRow(i);
                int firstCellNum = row.getFirstCellNum();
                int lastCellNum = row.getLastCellNum();
                for (int k = firstCellNum; k < lastCellNum; k++) {
                    HSSFCell cell = row.getCell(k);
                    switch (k) {
                    case 0:
                        id = (int) cell.getNumericCellValue();
                        break;
                    case 1:
                        name = cell.getStringCellValue();
                        break;
                    case 2:
                        age = (int) cell.getNumericCellValue();
                        break;
                    case 3:
                        sex = cell.getStringCellValue();
                        break;
                    case 4:
                        phoneNum = (long) cell.getNumericCellValue();
                        break;
                    case 5:
                        homeAddress = cell.getStringCellValue();
                        break;
                    case 6:
                        companyAddress = cell.getStringCellValue();
                        break;
                    }
                    arrayList.add(new User(id, name, age, sex, phoneNum, homeAddress, companyAddress));

                }

            }
        }


        for (User arrayLisst : arrayList) {
            System.out.println(arrayLisst.getId() + "|" + arrayLisst.getName() + "|" + arrayLisst.getAge() + "|"
                    + arrayLisst.getSex() + "|" + arrayLisst.getPhoneNum() + "|" + arrayLisst.getHomeAddress() + "|"
                    + arrayLisst.getCompanyAddress());
        }
        System.out.println("有这么多数据：" + (arrayList.size()/7));
        long currentTimeMillis1 = System.currentTimeMillis();
        long oo = currentTimeMillis1-currentTimeMillis;
        System.out.println("运行时间："+oo+"毫秒");
    }
}

实体类如下：

public class User {

    private int id;
    private String name;
    private int age;
    private String sex;
    private long phoneNum;
    private String homeAddress;
    private String companyAddress;
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
    public int getAge() {
        return age;
    }
    public void setAge(int age) {
        this.age = age;
    }
    public String getSex() {
        return sex;
    }
    public void setSex(String sex) {
        this.sex = sex;
    }
    public long getPhoneNum() {
        return phoneNum;
    }
    public void setPhoneNum(long phoneNum) {
        this.phoneNum = phoneNum;
    }
    public String getHomeAddress() {
        return homeAddress;
    }
    public void setHomeAddress(String homeAddress) {
        this.homeAddress = homeAddress;
    }
    public String getCompanyAddress() {
        return companyAddress;
    }
    public void setCompanyAddress(String companyAddress) {
        this.companyAddress = companyAddress;
    }
    public User(int id, String name, int age, String sex, long phoneNum, String homeAddress, String companyAddress) {
        super();
        this.id = id;
        this.name = name;
        this.age = age;
        this.sex = sex;
        this.phoneNum = phoneNum;
        this.homeAddress = homeAddress;
        this.companyAddress = companyAddress;
    }
    public User() {
        super();
        // TODO Auto-generated constructor stub
    }
    


}