Search code examples
jasper-reports

How do I remove default white fill in Jasper report when export to Excel?


When I export Jasper report to excel, it hides default excel boarders and fills the report lay out with white color. I tried selecting "Transparent" option in both "Style" properties and "Label" properties, still didn't work. I use JasperSoft studio. iReport Designer doesn't work in machine due to company policy.

Thank you.


Solution

  • In Jaspersoft Studio you can go to Preferences/Jaspersoft Studio/Exporters/Excel Exporter and uncheck White Page Background.

    Outside Jaspersoft Studio you would have to set the net.sf.jasperreports.export.xls.white.page.background property to false.