mirko.schmalmak

Isn't there a chance to get an xls WITH graphics?

P.S.: I've found this answer https://community.jaspersoft.com/questions/874366/jasper-export-image-xls-cell-cannot-be-added , but I've added commons-codec. And the graphics cannot be ignored.

In Java im exporting a JasperPrint document via JRXlsExporter to Excel format. It works, but when I'm including an image, I get the error "net.sf.jasperreports.engine.JRException: The cell cannot be added.". I'm using these jars: jasperreports-6.5.1.jar jasperreports-chart-customizers-6.5.1.jar jasperreports-chart-themes-6.5.1.jar jasperreports-fonts-6.5.1.jar jasperreports-functions-6.5.1.jar jasperreports-javaflow-6.5.1.jar commons-beanutils-1.9.3.jar commons-collections-3.2.2.jar commons-digester-2.1.jar joda-time-2.9.9.jar itext-2.1.7.js6.jar poi-3.15.jar commons-codec-1.10.jar What is wrong?

I've found a workaround for this under https://github.com/TIBCOSoftware/jasperreports/issues/22 - when this will be fixed by Jaspersoft?

I have to use Spring 5.0.3. Now I would like to use additionally JasperReports 6.5.1. But when executing the following ... MyBean b = new MyBean();List<MyBean> l = new ArrayList<>();l.add(b); String s = JasperFillManager.fillReportToFile("C:/PDF.jasper", new HashMap<String, Object>(), new JRBeanCollectionDataSource(l));[/code]... I get the following Exception: org.springframework.beans.factory.xml.XmlBeanDefinitionStoreException: Line 11 in XML document from URL [jar:file:/C:/EclipseWorkspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp6/wtpwebapps/myapp/WEB-INF/lib/jasperreports-chart-themes-6.5.1.jar!/net/sf/jasperreports/chartthemes/spring/beans/chartThemesBeans.xml] is invalid; nested exception is org.xml.sax.SAXParseException; lineNumber: 11; columnNumber: 38; cvc-complex-type.3.2.2: Attribut 'local' darf nicht in Element 'ref' vorkommen. at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.doLoadBeanDefinitions(XmlBeanDefinitionReader.java:398) ~[spring-beans-5.0.4.RELEASE.jar:5.0.4.RELEASE] at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:335) ~[spring-beans-5.0.4.RELEASE.jar:5.0.4.RELEASE] at org.springframework.beans.factory.xml.XmlBeanDefinitionReader.loadBeanDefinitions(XmlBeanDefinitionReader.java:303) ~[spring-beans-5.0.4.RELEASE.jar:5.0.4.RELEASE] at net.sf.jasperreports.extensions.SpringExtensionsRegistryFactory.getBeanFactory(SpringExtensionsRegistryFactory.java:111) ~[jasperreports-6.5.1.jar:6.5.1] at net.sf.jasperreports.extensions.SpringExtensionsRegistryFactory.createRegistry(SpringExtensionsRegistryFactory.java:76) ~[jasperreports-6.5.1.jar:6.5.1] at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.instantiateRegistry(DefaultExtensionsRegistry.java:295) ~[jasperreports-6.5.1.jar:6.5.1] at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.loadRegistries(DefaultExtensionsRegistry.java:270) ~[jasperreports-6.5.1.jar:6.5.1] at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.loadRegistries(DefaultExtensionsRegistry.java:190) [jasperreports-6.5.1.jar:6.5.1] at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.getRegistries(DefaultExtensionsRegistry.java:153) [jasperreports-6.5.1.jar:6.5.1] at net.sf.jasperreports.extensions.DefaultExtensionsRegistry.getExtensions(DefaultExtensionsRegistry.java:125) [jasperreports-6.5.1.jar:6.5.1] at net.sf.jasperreports.engine.util.JRStyledTextParser.<clinit>(JRStyledTextParser.java:86) [jasperreports-6.5.1.jar:6.5.1] at net.sf.jasperreports.engine.fill.JRBaseFiller.<init>(JRBaseFiller.java:111) [jasperreports-6.5.1.jar:6.5.1] at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:69) [jasperreports-6.5.1.jar:6.5.1] at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:57) [jasperreports-6.5.1.jar:6.5.1] at net.sf.jasperreports.engine.fill.JRFiller.createBandReportFiller(JRFiller.java:219) [jasperreports-6.5.1.jar:6.5.1] at net.sf.jasperreports.engine.fill.JRFiller.createReportFiller(JRFiller.java:234) [jasperreports-6.5.1.jar:6.5.1] at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:134) [jasperreports-6.5.1.jar:6.5.1] at net.sf.jasperreports.engine.JasperFillManager.fillToFile(JasperFillManager.java:504) [jasperreports-6.5.1.jar:6.5.1] at net.sf.jasperreports.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:888) [jasperreports-6.5.1.jar:6.5.1][/code]How to solve this?