Mark, 1) The files are from the same source and I suspect the where generated in the same way. In addition the files may have been upgraded from earlier version of Excel during their lifespan.
2) All of the files that fail have failed with the same error. 3) Since the files contains confidential data, it will be hard to make one available for the developers. If I can identify what in the file is causing the error, I can create a file for the developers. Although you mentioned stripping content from the file, what are some other debugging tools, techniques, and logging that can be used to determine what in the file is causing the error. Paul Spencer On Mar 27, 2010, at 4:09 AM, MSB wrote: > > Morning Paul, > > It sounds from that error message that the xml is malformed in some way; a > way that POI will not tolerate but Excel and OO will and one which is not > common to that file type (xlsm). Can you tell me please, are all of the > files that generate this same error from the same source, produced by the > same piece of software or contain the same macros? > > Also, and this is assuming that the files are large, is it possible for you > to create a very simple, small file that produces this exception? If you > can, and if you can then upload the file, that will help the developers to > identify which element in which file in the archive is producing the errors. > The way most people go about this is to systematically strip content from > the file while still producing the error. > > Yours > > Mark B > > > Paul Spencer-3 wrote: >> >> I am get the exception below thrown when reading in some .xlsm files into >> POI v3.6 WorkbookFactory.create(fileInputStream). The files open without >> error in Excel 2007 and OpenOffice 2.3. I have other .xlsm files that >> work as expected in POI v3.6. >> >> Any ideas on how to get more information on what is causing the " does not >> close tag <br>" error? >> >> Paul Spencer >> >> >>> Caused by: 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.POIXMLDocumentPart.read(POIXMLDocumentPart.java:261) >>> 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 >>> com.mikon.mes.mikon.server.importserver.bean.AbstractImportFileBean.fileUploaded(AbstractImportFileBean.java:110) >>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >>> at >>> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >>> at >>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >>> at java.lang.reflect.Method.invoke(Method.java:597) >>> at >>> org.apache.myfaces.el.MethodBindingImpl.invoke(MethodBindingImpl.java:132) >>> ... 31 more >>> 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:513) >>> at >>> org.apache.poi.xssf.usermodel.XSSFFactory.createDocumentPart(XSSFFactory.java:59) >>> ... 42 more >>> Caused by: org.apache.xmlbeans.XmlException: error: does not close tag >>> <br>. >>> at >>> org.apache.xmlbeans.impl.store.Locale$SaxLoader.load(Locale.java:3471) >>> at >>> org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1270) >>> at >>> org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1257) >>> at >>> org.apache.xmlbeans.impl.schema.SchemaTypeLoaderBase.parse(SchemaTypeLoaderBase.java:345) >>> at org.apache.xmlbeans.XmlObject$Factory.parse(XmlObject.java:663) >>> at >>> org.apache.poi.xssf.usermodel.XSSFVMLDrawing.read(XSSFVMLDrawing.java:101) >>> at >>> org.apache.poi.xssf.usermodel.XSSFVMLDrawing.<init>(XSSFVMLDrawing.java:96) >>> ... 47 more >>> Caused by: org.xml.sax.SAXParseException: does not close tag <br>. >>> at >>> org.apache.xmlbeans.impl.piccolo.xml.Piccolo.reportFatalError(Piccolo.java:1038) >>> at org.apache.xmlbeans.impl.piccolo.xml.Piccolo.parse(Piccolo.java:723) >>> at >>> org.apache.xmlbeans.impl.store.Locale$SaxLoader.load(Locale.java:3439) >>> ... 53 more >>> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [email protected] >> For additional commands, e-mail: [email protected] >> >> >> > > -- > View this message in context: > http://old.nabble.com/%22org.xml.sax.SAXParseException%3A-%3C-b%3E-does-not-close-tag-%3Cbr%3E.%22-when-opening-some-.xlsm-files-tp28047195p28050810.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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
