How to export content of a page header band in JasperReport to Excel's header?

[stevanzaric]

I need to export reports from Jasper to Excel. I am using iReport 5.6.0. The thing that I don't know how to achieve is to export content of a page header band to Excel's header, and similarly, the content of a page footer band to appear in Excel's footer.

I'm aware of existing properties, e.g. net.sf.jasperreports.export.xls.sheet.footer.center, but with that I can only set static text in Excel's footer.

[lisaws]

There is an equivalent property for setting the header called net.sf.jasperreports.export.xls.sheet.header.center (http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.xls.sheet.header.center).

To set a dynamic value - in the Add/modify property window, select the 'Use an expression' checkbox and then you can use whatever expression you want.

[stevanzaric]

Thank you, but it seems that for global property I cannot set a dyinamic value (there is no 'Use an expression' checkbox).