java+poi样例_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]);

}

}