java使用poi讀取excel文件代碼示例

import java.io.FileInputStream;
import java.io.IOException;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
/**


@author la
POI工具讀取Excel文件/
public class ParseExcel {
private void parseExcel(String excelFile)throws IOException {

 POIFSFileSystem fs=new POIFSFileSystem(new FileInputStream(excelFile));//打開Excel文件
 HSSFWorkbook wbHssfWorkbook=new HSSFWorkbook(fs);//打開工作薄
 HSSFSheet sheet=wbHssfWorkbook.getSheetAt(0);//打開工作表

 HSSFRow row=null;
 String data=null;
 for (int i = 0; i <=sheet.getLastRowNum(); i++) {//循環讀取每一行
     row =sheet.getRow(i);
     for (int j = 0; j <= row.getLastCellNum(); j++) {//循環讀取每一列
         switch (row.getCell((short)j).getCellType()) {//判斷單元格的數據類型
         case HSSFCell.CELL_TYPE_BLANK:
             data="";
             break;
         case HSSFCell.CELL_TYPE_NUMERIC:
             data=(long)row.getCell((short)j).getNumericCellValue()+"";
             break;
         default:
             data=row.getCell((short)j).getStringCellValue();
             break;
         }
         System.out.print(data+"\t");
     }
     System.out.println();
 }

}
 /**

@param args
void/
public static void main(String[] args)throws IOException {
 new ParseExcel().parseExcel(args[0]);
}



}
</pre>