Hi,
I am able to read the data from xls but i am not able to read xlsx
file......can u please help me what i have to do to read xlsx file...its
urgent......
Here is the my code......
package file1;
import java.io.FileInputStream;
import java.util.Iterator;
import java.util.Vector;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
public class RowAlter1 {
public static void main( String [] args ) {
//System.out.println(1111111111);
String fileName="C://hapi/home1/Excel1.xls";
//Read an Excel File and Store in a Vector
// System.out.println("2222222222" +fileName);
Vector dataHolder=readExcelFile(fileName);
//Print the data read
printCellDataToConsole(dataHolder);
// System.out.println("333333" +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**/
//System.out.println("4444444" +myInput);
POIFSFileSystem myFileSystem = new POIFSFileSystem(myInput);
/** Create a workbook using the File System**/
//System.out.println("5555555" + myfilesystem);
HSSFWorkbook myWorkBook = new HSSFWorkbook(myFileSystem);
/** Get the first sheet from workbook**/
HSSFSheet mySheet = myWorkBook.getSheetAt(1);
/** We now need something to iterate through the cells.**/
Iterator rowIter = mySheet.rowIterator();
//System.out.println("6666666" +rowIter);
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++){
if(i==0||i==2)
continue;
// if(i==2)
// continue;
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();
}
}
}
thanks,
Reddy,
email:[email protected]
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/to-read-data-from-Xlsx-file-but-able-to-read-xls-tp4590181p4590181.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
