javaIO流使用POI工具包解析excel表

解析excel文档LZ用的是poi-3.10-FINAL.jar这个工具包

以上是LZ用的excel表的格式

<span style="font-size:14px;">public class Student {
		private String name;
	
		private String address;

		private Date birthday;

		private String classes;

		private int gender;

		private String mobileNumber;
		
		private String nationId;

		private String schools;
		
		@Override
		public String toString() {
			return "Student [name=" + name + ", address=" + address
					+ ", birthday=" + birthday + ", classes=" + classes
					+ ", gender=" + gender + ", mobileNumber=" + mobileNumber
					+ ", nationId=" + nationId + ", schools=" + schools + "]";
		}
                //get set 省略....
</span>

以上是用户类，这里用的是一个student类

<span style="font-size:14px;">import java.io.File;
import java.io.FileInputStream;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

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.apache.poi.poifs.filesystem.POIFSFileSystem;


public class ExcelClass{
	public static void main(String[] args) throws Exception {
		
		List<Student> list = new ArrayList<Student>();
		File file1 = new File("E:"+File.separator+"1.xls");
		FileInputStream fis = new FileInputStream(file1);
		
		POIFSFileSystem fs = new POIFSFileSystem(fis);
		HSSFWorkbook hwb = new HSSFWorkbook(fs);
		HSSFSheet sheet = hwb.getSheet("学生");
		
		if(sheet==null){
			System.out.println("没有学生表");
			return;
		}
		
		System.out.println(sheet.getFirstRowNum());//行和列都是从0开始计数  此处应该为1
		
		HSSFRow titleRow = sheet.getRow(sheet.getFirstRowNum());//获取标题行
		
		Map<String,Integer> map = new HashMap<String,Integer>();//此处将标题与列数放到map集合中，保证以后excel列位置即使改变也能同样解析
		System.out.println(titleRow.getLastCellNum());//9  （列数的最后一列+1） 
		
		for(int i=titleRow.getFirstCellNum();i<titleRow.getLastCellNum();i++){
			map.put(titleRow.getCell(i).getStringCellValue(), i);//key是标题名，value是列数
		}
		System.out.println(map);
		/**
		 * 取标题下面的数据，并且将它们封装到student对象中
		 */
		for(int i=sheet.getFirstRowNum()+1;i<=sheet.getLastRowNum();i++){
			HSSFRow dataRow = sheet.getRow(i);//获得遍历到的那一行
			Student stu = new Student();
			//遍历一行中的单元格
			for(String item:map.keySet()){
				HSSFCell dataCell = dataRow.getCell(map.get(item));//根据列值确定一行中的单元格
				/**
				 * 从一行中循环取出对应标题下的值
				 */
				if("用户姓名".equals(item)){
					stu.setName(dataCell.getStringCellValue());
				}
				else if("用户地址".equals(item)){
					stu.setAddress(dataCell.getStringCellValue());
				}
				else if("用户生日".equals(item)){
					stu.setBirthday(dataCell.getDateCellValue());
				}
				else if("用户班级".equals(item)){
					stu.setClasses(new Integer((int)dataCell.getNumericCellValue()).toString());
				}
				else if("性别".equals(item)){
					stu.setGender((int)dataCell.getNumericCellValue());
				}
				else if("手机号码".equals(item)){
					stu.setMobileNumber(dataCell.getStringCellValue());
				}
				else if("身份证号码".equals(item)){
					stu.setNationId(dataCell.getStringCellValue());
				}
				else if("用户学校".equals(item)){
					stu.setSchools(dataCell.getStringCellValue());
				}
			}
			list.add(stu);
		}
		System.out.println(list);
		
	}
}
</span>

以上是解析excel的解析类

结果：

[Student [name=abcde, address=abcvfg, birthday=Wed Oct 02 00:00:00 CST 1991, classes=5, gender=1, mobileNumber=13145678911, nationId=12345678912345301, schools=zxwe111],

Student [name=abcde1, address=abcvfg1, birthday=Sat Oct 03 00:00:00 CST 1992, classes=6, gender=2, mobileNumber=13145678912, nationId=12345678912345302, schools=zxwe112],

Student [name=abcde2, address=abcvfg2, birthday=Mon Oct 04 00:00:00 CST 1993, classes=7, gender=1, mobileNumber=13145678913, nationId=12345678912345303, schools=zxwe113],

Student [name=abcde3, address=abcvfg3, birthday=Wed Oct 05 00:00:00 CST 1994, classes=8, gender=2, mobileNumber=13145678914, nationId=12345678912345304, schools=zxwe114],

Student [name=abcde4, address=abcvfg4, birthday=Fri Oct 06 00:00:00 CST 1995, classes=9, gender=1, mobileNumber=13145678915, nationId=12345678912345305, schools=zxwe115]]

注意：1,使用getLastCellNum方法获得的值是最后一列的索引值（这里excel表最后一列的索引值是从左到右从0开始数一直到8）

               加1 

            2,请看下用户班级和手机号码，这里的用户班级在poi解析时是当数字解析的，而手机号码是当字符串解析的，如果你想让它

               当字符串解析，把excel格子中的数字开头加’  即可！