Jump to content
We've recently updated our Privacy Statement, available here ×

Excel export: show data inside excel header row


Recommended Posts


when exporting my report to Excel, I would like to put some data (in my case an jpeg) into the excel header row. According to some older posts in this forum, this does not seem to be possible (maybe it works with the help of Java Excel APIs, but I cannot use them inside JasperStudio). 

I also found a "net.sf.jasperreports.export.xls.sheet.header.center" property, but I don´t know how to set a image file there.

Are there any new features in the latest versions of JasperReports, or does anybody know how to write data into Excel header/footer rows?



Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

it looks like "net.sf.jasperreports.export.xls.sheet.header.center" is used for getting the sheet header center value from a excel datasource.


May be you can try initiating a macro when the report generates to include a excel header.

refer : http://thinkinginsoftware.blogspot.com/2011/11/excel-jasper-reports-with-macros.html




Link to comment
Share on other sites

  • 1 month later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...