Setting JasperReports to insert page number in Excel sheet

0

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's picture
48803
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 months 6 days ago

1 Answer:

0

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.

hozawa's picture
48803
Joined: Apr 24 2010 - 4:31pm
Last seen: 3 months 6 days ago
Feedback