• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Junilu Lacar
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Knute Snortum
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Ron McLeod
  • Carey Brown
Bartenders:
  • Paweł Baczyński
  • Piet Souris
  • Vijitha Kumara

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

 
Greenhorn
Posts: 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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)
 
World domination requires a hollowed out volcano with good submarine access. Tiny ads are optional.
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!