*
The moose likes Other JSE/JEE APIs and the fly likes Exception in thread Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Other JSE/JEE APIs
Bookmark "Exception in thread "main" java.lang.IllegalArgumentException: Your InputStream was neither an OLE2 " Watch "Exception in thread "main" java.lang.IllegalArgumentException: Your InputStream was neither an OLE2 " New topic
Author

Exception in thread "main" java.lang.IllegalArgumentException: Your InputStream was neither an OLE2

Ram Mullangi
Greenhorn

Joined: Apr 06, 2011
Posts: 2
My client requirement is to upload an Excel File (which is generated from another system). To upload this generated Excel File, I am using Apache POI api. The following jar files are in the classpath of my application.

dom4j-1.6.1
ooxml-schemas-1.0
poi-3.5-FINAL
poi-ooxml-3.5-FINAL
xmlbeans-2.3.0
openxml4j-1.0-beta.jar

I am getting the following exception(using Apache POI3.5)

Exception in thread "main" java.lang.IllegalArgumentException: Your InputStream was neither an OLE2 stream, nor an OOXML stream
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:65)
at PoiExcelRead.main(PoiExcelRead.java:22)


when my code is

17 public static void main(String[] args) throws IOException, InvalidFormatException {
18 // TODO Auto-generated method stub
19
20 String xlsPath = "d://BOM70914831.xls";
21 InputStream myxls = new FileInputStream(xlsPath);
22 Workbook workBook = WorkbookFactory.create(myxls);
23 }



and I am getting the following exception(using Apache POI3.0)

Exception in thread "main" java.io.IOException: Invalid header signature; read 0x6D78206C6D74683C, expected 0xE11AB1A1E011CFD0
at org.apache.poi.poifs.storage.HeaderBlockReader.<init>(HeaderBlockReader.java:120)
at org.apache.poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSystem.java:151)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:317)
at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:298)
at PoiExcelRead.main(PoiExcelRead.java:22)

when my code is
17 public static void main(String[] args) throws IOException {
18 // TODO Auto-generated method stub
19
20 String xlsPath = "d://BOM70914831.xls";
21 InputStream myxls = new FileInputStream(xlsPath);
22 HSSFWorkbook wb = new HSSFWorkbook(myxls);
23 }


Please find the sample excel file(http://www.mediafire.com/?ovj4fs2mkcou01e) to check my issue as an attachment.

Note: It is working when I open the file using Microsoft Excel and saving it as another file(using File>Save As option from Microsoft Excel Menu)
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Exception in thread "main" java.lang.IllegalArgumentException: Your InputStream was neither an OLE2
 
Similar Threads
reading password protected excel sheet
Can we refresh the directory from middle of java code
error reading excel file using apache poi
ClassCastExcepiton Using POI
NullPointerException