Hi, I have a problem in regards to using apache POI for reading data from xlsx files. I'm getting the POIXMLException caused by IOException: error: Unexpected character encountered as stated below. I've done some searching and found similar problems like:
http://apache-poi.1045710.n5.nabble.com/DO-NOT-REPLY-Bug-48936-New-Writing-specific-sequence-of-strings-to-XSSFSheet-results-in-malformed-XML-td2339732.html or http://apache-poi.1045710.n5.nabble.com/DO-NOT-REPLY-Bug-48433-New-org-apache-poi-POIXMLException-java-lang-reflect-InvocationTargetExceptio-td2327021.html I've added all dependencies (including geronimo_stax_api,...) and my application works for xls, and some xlsx documents, but tends to fail parsing some xlsx documents. The application is somewhat specific because it's running on Oracle 11.0.1 Production database on Linux operating system. The database has integrated java 1.5 virtual machine. I'm using POI 3.6. Does anyone have any experience with these sorts of errors or any suggestions how to proceed. Is upgrading to newer versions of POI the solution? I'd be glad to add any additional information if necessary, and I'm sorry if I'm duplicating questions, I was unable to find a solution and I'm new to this mailig list. Best regards, Davor Delač Exception in thread "Root Thread" org.apache.poi.POIXMLException: java.lang.reflect.InvocationTargetException at org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:61) at org.apache.poi.POIXMLDocumentPart.read(POIXMLDocumentPart.java:256) at org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:196) at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:172) at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:63) at in2.apex_obi.ExcelReader.<init>(in2.apex_obi.ExcelReader:22) at in2.apex_obi.Excel2DB.convert(Excel2DB:8) Caused by: java.lang.reflect.InvocationTargetException at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:511) at org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:59) ... 6 more Caused by: java.io.IOException: error: Unexpected character encountered (lex state 10): '<' at org.apache.poi.xssf.model.StylesTable.readFrom(StylesTable.java:134) at org.apache.poi.xssf.model.StylesTable.<init>(StylesTable.java:91) ... 11 more -- View this message in context: http://apache-poi.1045710.n5.nabble.com/POIXMLException-reading-xlsx-tp4872709p4872709.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
