Is there a way to insert page number in xls export file?
I've tried to use "net.sf.jasperreports.export.xls.sheet.header.left" property to insert &[Page] but it does not work properly.
It's inserted as a text instead of a number.
However, I've found that if I open the header from Excel, Excel converts the text to page numbers.
Is there a way so I don't have to open header on each Excel sheet to print page number in a header.
Posted on July 12, 2015 at 2:13am
Looking a the code, found JasperReports doesn't support adding Excel header/footer functions.
I've been able to modify JasperReports library to do this. Works very well.