Home:ALL Converter>jasperreports: how to include chart in xlsx (Excel) report?

jasperreports: how to include chart in xlsx (Excel) report?

Ask Time:2019-03-08T20:23:52         Author:badbishop

Json Formatter

At the moment, when I export report to XLSX (MS Excel) format, there is a white void at the top of the spreadsheet preceding the data - I guess, it is supposed to be the chart :). The report is also exported as HTML, PDF and JSON, all three without any visible issue.

I'm using JasperReport "community" edition. Here are the relevant lines from my build.gradle:

implementation group: 'net.sf.jasperreports', name: 'jasperreports', version: "6.6.0"
implementation group: 'net.sf.jasperreports', name: 'jasperreports-fonts', version: '6.0.0'

I found a few posts suggesting to set the property net.sf.jasperreports.export.xls.ignore.graphics to false.

OK, did that in the report template:

<jasperReport ..>
   <property name="net.sf.jasperreports.export.xls.ignore.graphics" value="false"/>

Still a white hole instead of a chart.

Is there a solution to this issue, or do I just have to live with it?

Author:badbishop,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/55063181/jasperreports-how-to-include-chart-in-xlsx-excel-report
yy