wisoo123 Posted December 12, 2016 Share Posted December 12, 2016 Hi,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?ThanksWisoo123 Link to comment Share on other sites More sharing options...
reportdev Posted December 12, 2016 Share Posted December 12, 2016 it looks like "net.sf.jasperreports.export.xls.sheet.header.center" is used for getting the sheet header center value from a excel datasource.http://jasperreports.sourceforge.net/config.reference.html#net.sf.jasperreports.export.xls.sheet.header.centerMay 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 More sharing options...
wisoo123 Posted February 9, 2017 Author Share Posted February 9, 2017 Thanks for the advice to use macros in this case. I did already read this blog before, but unfortunatelymacros are not allowed in our environment. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now