导入java.io.FileInputStream;导入java.util.Iterator;导入java.util.Vector;导入org.apache.poi.hssf.usermodel.HSSFCell;导入org.apache.poi.hssf.usermodel.HSSFRow;导入org.apache.poi.hssf.usermodel.HSSFSheet;导入org.apache.poi.hssf.usermodel.HSSFWorkbook;导入org.apache.poi.poifs.filesystem.POIFSFileSystem;公共类ReadExcelFile {public static void main( String [] args ) { String fileName="C:\temp\testPOI.xls"; //Read an Excel File and Store in a Vector Vector dataHolder=readExcelFile(fileName); //Print the data read printCellDataToConsole(dataHolder);}public static Vector readExcelFile(String fileName){ Vector cellVectorHolder = new Vector(); try{ //InputStream myInput= ReadExcelFile.class.getResourceAsStream( fileName ); FileInputStream myInput = new FileInputStream(fileName); POIFSFileSystem myFileSystem = new POIFSFileSystem(myInput); HSSFWorkbook myWorkBook = new HSSFWorkbook(myFileSystem); HSSFSheet mySheet = myWorkBook.getSheetAt(0); Iterator rowIter = mySheet.rowIterator(); while(rowIter.hasNext()){ HSSFRow myRow = (HSSFRow) rowIter.next(); Iterator cellIter = myRow.cellIterator(); Vector cellStoreVector=new Vector(); while(cellIter.hasNext()){ HSSFCell myCell = (HSSFCell) cellIter.next(); cellStoreVector.addElement(myCell); } cellVectorHolder.addElement(cellStoreVector); } }catch (Exception e){e.printStackTrace(); } return cellVectorHolder;}private static void printCellDataToConsole(Vector dataHolder) { for (int i=0;i<dataHolder.size(); i++){ Vector cellStoreVector=(Vector)dataHolder.elementAt(i); for (int j=0; j < cellStoreVector.size();j++){ HSSFCell myCell = (HSSFCell)cellStoreVector.elementAt(j); String stringCellValue = myCell.toString(); System.out.print(stringCellValue+"t"); } System.out.println(); }}}



