JRXlsExporter and images: The cell cannot be added

[mirko.schmalmak]

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?

[mirko.schmalmak]

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.

[riodavid]

Try set [net.sf.jasperreports.export.xls.ignore.graphics] to [false] in your report properties.

[mirko.schmalmak]

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

[dev_1313]

I got the same problem. I fixed it by copying the file org.apache.commons.codec_1.9.0.v20170208-1614.jar from the folder "C:Program FilesTIBCOJaspersoft Studio-6.6.0plugins" to my deployment folder.