栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 面试经验 > 面试问答

如何使用Apache POI读取所有单元格值?

面试问答 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

如何使用Apache POI读取所有单元格值?

导入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();    }}

}



转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/496224.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号