https://issues.apache.org/bugzilla/show_bug.cgi?id=51031
Summary: Exception in thread "main"
java.lang.IllegalArgumentException: Your InputStream
was neither an OLE2 stream, nor an OOXML stream
Product: POI
Version: 3.5-FINAL
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: major
Priority: P2
Component: POIFS
AssignedTo: [email protected]
ReportedBy: [email protected]
Created an attachment (id=26861)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=26861)
Sample Excel File
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(BOM70914831.xls) 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)
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
