poi遍歷Excel檔案

1. 遍歷Excel檔案：   
2.   
3. FileInputStream fileInputStream = new FileInputStream( "c:/temp/test.xls" );   
4.         POIFSFileSystem fileSystem = new POIFSFileSystem( fileInputStream );   
5.         fileInputStream.close();   
6.   
7.         HSSFWorkbook workbook = new HSSFWorkbook( fileSystem );   
8.         for( int i = 0; i < workbook.getNumberOfSheets(); i++ ){   
9.             HSSFSheet sheet = workbook.getSheetAt( i );   
10.             if( sheet != null ){   
11.                 for( int j = sheet.getFirstRowNum(); j < sheet.getLastRowNum(); j++ ){   
12.                     HSSFRow row = sheet.getRow( j );   
13.                     if( null != row ){   
14.                         for( int k = row.getFirstCellNum(); k < row.getLastCellNum(); k++ ){   
15.                             HSSFCell cell = row.getCell( k );   
16.                             if( null != cell ){   
17.                                 int type = cell.getCellType();   
18.                                 switch( type ){   
19.                                     case HSSFCell.CELL_TYPE_NUMERIC:   
20.                                         System.out.print( cell.getNumericCellValue() + "/t" );   
21.                                         break;   
22.                                     case HSSFCell.CELL_TYPE_BOOLEAN:   
23.                                         System.out.print( cell.getBooleanCellValue() + "/t" );   
24.                                         break;   
25.                                     case HSSFCell.CELL_TYPE_ERROR:   
26.                                         System.out.print( cell.getErrorCellValue() + "/t" );   
27.                                         break;   
28.                                     case HSSFCell.CELL_TYPE_FORMULA:   
29.                                         System.out.print( cell.getCellFormula() + "/t" );   
30.                                         break;   
31.                                     case HSSFCell.CELL_TYPE_STRING:   
32.                                         System.out.print( cell.getRichStringCellValue() + "/t" );   
33.                                         break;   
34.                                     default:   
35.                                         break;   
36.                                 }   
37.                             }   
38.                         }   
39.                         System.out.println();   
40.                     }   
41.                 }   
42.             }   
43.         }