File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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


Win a copy of Spring in Action this week in the Spring forum!
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