Removing Color background while exporting Jasper Report to Excel.

0

Hi all,

I have created a report in the form of table which has color background for alternate columns. The report works perfectly and is exporting to pdf with color background of cells which is as needed.

But, I need to ignore the background color while exporting to Excel. I have used iReport to create the jrxml file. I tried by selecting the checkmark for 'Opaque'. But this is ignoring the colors in the display in jasper server and also in pdf.

I would appreciate any help in getting over this problem

Regards

Sudheendra

swalvekar's picture
Joined: Dec 6 2010 - 8:23am
Last seen: 7 years 1 month ago

2 Answers:

2

These might be of interest, just change them in your jasperreports.properties file (http://jasperreports.sourceforge.net/config.reference.html)

 

 

net.sf.jasperreports.export.xls.ignore.cell.background

 


 

net.sf.jasperreports.export.xls.white.page.background

 

ernestoo's picture
9054
Joined: Nov 29 2010 - 11:59am
Last seen: 2 years 2 months ago
0

 Thank you very much. Your solution worked.

Regards

Sudheendra

swalvekar's picture
Joined: Dec 6 2010 - 8:23am
Last seen: 7 years 1 month ago
Feedback