Setting JasperReports to insert page number in Excel sheet

[hozawa]

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.

[hozawa]

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.