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]
