Bug 62429 - Not Able to read 2016 MS-Excel file Containing TreeMap using InputStreamReader JAVA
Summary: Not Able to read 2016 MS-Excel file Containing TreeMap using InputStreamReade...
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.17-FINAL
Hardware: PC All
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on: 66650
Blocks:
  Show dependency tree
 
Reported: 2018-06-05 04:14 UTC by Rami Reddy
Modified: 2023-06-15 20:04 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.