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]); 
    } 
 
}