Thankx for your quick reply. I have gone through apache site,
http://poi.apache.org/spreadsheet/quick-guide.html and
applied ss package classes but still getting the error.
I added following jar files in my lib folder:
ooxml-schemas-1.0.jar
dom4j-1.6.1.jar
poi-3.5-FINAL-20090928.jar
poi-contrib-3.5-FINAL-20090928.jar
poi-scratchpad-3.5-FINAL-20090928.jar
poi-ooxml-3.5-FINAL-20090928.jar
Modified Code in try block:
------------------------------
import statements used are,
import org.apache.log4j.Logger;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
private Workbook wb = null;
public ExcelParser(File file) throws MatrixException {
this.file = file;
POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(file));
this.wb = WorkbookFactory.create(fs);
}
I am getting following error.
java.io.IOException: Invalid header signature; read 1688935826934608, expected -2226271756974174256
at org.apache.poi.poifs.storage.HeaderBlockReader.<init>(HeaderBlockReader.java:88)
at org.apache.poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSystem.java:83)
at com.ericsson.mars.util.ExcelParser.<init>(ExcelParser.java:142)
Any solution on this??