Java – JasperReports exported to Excel ignoring background color

export-to-exceljasper-reportsjava

Have you ever had alternating background colors in a Jasper report and then exported it to Excel? The Excel export seems to ignore the alternating color.

I've got a Jasper report where the rows alternating background color using the procedure referenced HERE. When I preview it using the viewer or export to PDF it works — but not when I export to Excel. I've tried using JRXlsExporter and JExcelApiExporter both to no avail.

I think it might be a side-effect of how you have to make alternating row colors in Jasper, which I despise to begin with, but have found no other way.

Thanks in advance!

Best Answer

Also, Be sure that the conditional styles you make, have the "opaque" option checked... If not, the background color will never apper in the excel report (never!!!)....

Also, The "opaque" option must be checked in the text fields....

And if you noticed that the text fields never took the style that you gave to them, try to set the forecolor and background to null, in the properties panel of each text field (this works for me)...

Hope this help... bye.

Related Solutions

How to set dynamically isIgnorePagination in jasper report

According to JasperReports sample reference:

For various purposes this flag [isIgnorePagination in jrxml] can be overriden at report filling time using the optional built-in IS_IGNORE_PAGINATION parameter.

So the code should be something like this:

final Map<String, Object> fillingParameters = new HashMap<>();
if (exportType == ExportType.XLS) {
    fillingParameters.put(JRParameter.IS_IGNORE_PAGINATION, Boolean.TRUE);
}
final JasperPrint print = JasperFillManager.fillReport(jasperReport, fillingParameters, dataSource);

Java – jasperreports – excel export

Thanks for all help, i figured out what caused the problem, i was using the same bean List both for the pdf report and for the xls,and for some reason when i was passing the list to fillReport() to create the print object for the pdf, all beans where removed from the list. I created a second JRBeanCollection for the xls Print object and everything works fine!

Best Answer

Related Solutions

How to set dynamically isIgnorePagination in jasper report

Java – jasperreports – excel export

Related Topic