Bug 62429

Summary:	Not Able to read 2016 MS-Excel file Containing TreeMap using InputStreamReader JAVA
Product:	POI	Reporter:	Rami Reddy <arepalli.ram1987>
Component:	XSSF	Assignee:	POI Developers List <dev>
Status:	NEW ---
Severity:	normal
Priority:	P2
Version:	3.17-FINAL
Target Milestone:	---
Hardware:	PC
OS:	All
Bug Depends on:	66650
Bug Blocks:

Description Rami Reddy 2018-06-05 04:14:39 UTC

run:
org.apache.poi.POIXMLException: java.lang.reflect.InvocationTargetException
 at org.apache.poi.POIXMLFactory.createDocumentPart(POIXMLFactory.java:63)
 at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:580)
 at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:592)
 at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:592)
 at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:165)
 at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:270)
 at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:184)
 at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:149)
 at TestingFileRead.main(TestingFileRead.java:24)
Caused by: java.lang.reflect.InvocationTargetException
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
 at org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:56)
 at org.apache.poi.POIXMLFactory.createDocumentPart(POIXMLFactory.java:60)
 ... 8 more
Caused by: org.apache.xmlbeans.XmlException: error: The document is not a chartSpace@http://schemas.openxmlformats.org/drawingml/2006/chart: document element namespace mismatch expected "http://schemas.openxmlformats.org/drawingml/2006/chart" got "http://schemas.microsoft.com/office/drawing/2014/chartex"
 at org.apache.xmlbeans.impl.store.Locale.verifyDocumentType(Locale.java:459)
 at org.apache.xmlbeans.impl.store.Locale.autoTypeDocument(Locale.java:364)
 at org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1391)
 at org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1370)
 at org.apache.xmlbeans.impl.schema.SchemaTypeLoaderBase.parse(SchemaTypeLoaderBase.java:370)
 at org.apache.poi.POIXMLTypeLoader.parse(POIXMLTypeLoader.java:164)
 at org.openxmlformats.schemas.drawingml.x2006.chart.ChartSpaceDocument$Factory.parse(Unknown Source)
 at org.apache.poi.xssf.usermodel.XSSFChart.<init>(XSSFChart.java:108)
 ... 14 more
BUILD SUCCESSFUL (total time: 1 second)

Comment 1 PJ Fanning 2018-06-05 17:07:58 UTC

I think that POI uses an older version of the Microsoft OOXML xsds when generating bindings.
http://schemas.microsoft.com/office/drawing/2014/chartex is probably too new for our existing bindings.

Comment 2 PJ Fanning 2018-06-05 17:10:26 UTC

https://github.com/plutext/docx4j may be worth trying

Comment 3 Dominik Stadler 2018-06-28 15:06:40 UTC

Reduce severity as this is actually a missing feature where the whole charting-area is in need of more volunteers to improve support, currently POI is lacking almost all features for charting.