java读取Excel文档内容

所需jar包

1.初始化HSSFWorkbook、HSSFSheet对象

HSSFWorkbook：Excel的文档对象
HSSFSheet：Excel的sheet页对象

		//获取Excel文件，并转为HSSFWorkbook
        HSSFWorkbook wb = new HSSFWorkbook(new FileInputStream(new File("D:\\TMP\\OutPutSource.xls")));
        //获取第一sheet页，也可根据名称获取sheet页
        HSSFSheet sheet = wb.getSheetAt(0);
        //取得当前sheet页行数
        int rownum = sheet.getPhysicalNumberOfRows();

2.初始化Row(行)对象

		Row row = null;
        int cellnum = 0;
        String cellData = null;
        //sheet页中最大的列数，防止取数取不到
        for (int i = 0; i < rownum; i++) {
        	//获取当前行对象
			row = sheet.getRow(i);
			int rowCellnum = row.getPhysicalNumberOfCells();
			if(rowCellnum > cellnum){
				cellnum = rowCellnum;
			}
		}

3.获取数据

for (int i = 1; i < rownum; i++) {
        	cellData = null;
        	row = sheet.getRow(i);
        	if (row != null) {
				for(int j = 0; j < cellnum; j++) {
					//根据获取类型选则方法
					cellData = cellData + "@"+ row.getCell(j).getRichStringCellValue().getString();
				}
				String[] infos = cellData.split("@");
				String str1 = infos[0];
				String str2 = infos[1];
			} else {
				break;
			}
        }