Java中通过POI读取Excel 2003 - 2007的xls,xlsx格式

	@Test
	public void testRead() throws IOException, InvalidFormatException {
		// String fileName = "e:/workbook.xls";
		String fileName = "e:/workbook.xlsx";
		Workbook wb = WorkbookFactory.create(new FileInputStream(fileName));

		int sheetNum = wb.getNumberOfSheets();

		for (int i = 0; i < sheetNum; i++) {
			Sheet childSheet = wb.getSheetAt(i);
			int rowNum = childSheet.getLastRowNum();

			for (int j = 0; j < rowNum; j++) {
				Row row = childSheet.getRow(j);
				int cellNum = row.getLastCellNum();

				for (int k = 0; k < cellNum; k++) {
					System.out.print(row.getCell(k).toString() + " ");
				}
				System.out.println();
			}

		}
	}