comment lire toute la valeur de la cellule en utilisant Apache POI?

Je veux lire toutes les cellules de la valeur à partir d'une feuille excel à l'aide d'Apache POI, et le stocker dans une dimension de tableau de chaîne .Il est possible de lire les données à partir d'excel, ligne par ligne, et en extraire la valeur de chaque cellule?

Merci de m'aider à résoudre ce problème.

Grâce

source d'informationauteur Sameek Mishra | 2011-06-30

  1. 13

    import java.io.FileInputStream; 
import java.util.Iterator; 
import java.util.Vector;
     

    import org.apache.pi.hssf.usermodel.HSSFCell; 
import org.apache.pi.hssf.usermodel.HSSFRow; 
import org.apache.pi.hssf.usermodel.HSSFSheet; 
import org.apache.pi.hssf.usermodel.HSSFWorkbook; 
import org.apache.pi.poifs.système de fichiers.POIFSFileSystem;
     

    public class 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)
{
/** --Define a Vector
--Holds Vectors Of Cells
*/
Vector cellVectorHolder = new Vector();
try{
/** Creating Input Stream**/
//InputStream myInput= ReadExcelFile.class.getResourceAsStream( fileName );
FileInputStream myInput = new FileInputStream(fileName);
/** Create a POIFSFileSystem object**/
POIFSFileSystem myFileSystem = new POIFSFileSystem(myInput);
/** Create a workbook using the File System**/
HSSFWorkbook myWorkBook = new HSSFWorkbook(myFileSystem);
/** Get the first sheet from workbook**/
HSSFSheet mySheet = myWorkBook.getSheetAt(0);
/** We now need something to iterate through the cells.**/
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();
}
}

    }

  2. 6

    Il y a un document sur Javaworld, C'est PI-Parfait vous montrer comment cela est réalisé.

    Exemple:

    String fileName = "C:/MyExcelFile.xls"; //file we are interested in
POIFSFileSystem fileSystem = new POIFSFileSystem(new FileInputStream(fileName));
HSSFWorkbook workbook = new HSSFWorkbook(fileSystem);
HSSFSheet sheet = workbook.getSheetAt(0); //Get first Excel Sheet
//Iterate throw each row.
Iterator<Row> rows = sheet.rowIterator();
while (rows.hasNext()) {
HSSFRow row = (HSSFRow) rows.next();
Iterator<Cell> cells = row.cellIterator();
while (cells.hasNext()) {
HSSFCell cell = (HSSFCell) cells.next();
//Must do this, you need to get value based on the cell type
switch (cell.getCellType()) {
case HSSFCell.CELL_TYPE_NUMERIC:
System.out.println(cell.getNumericCellValue());
break;
case HSSFCell.CELL_TYPE_STRING:
System.out.println(cell.getStringCellValue());
break;
default: break;
}
}
}