How can I create an excel report with fixed header using JapserReports?
I mean that I need the header to be fixed when I scroll the Excel file.
Fixed header in Excel using JasperReports
export-to-exceljasper-reports
export-to-exceljasper-reports
How can I create an excel report with fixed header using JapserReports?
I mean that I need the header to be fixed when I scroll the Excel file.
Best Answer
This is currently possible by adding a couple properties in the jrxml file for each report. Take a look at Advanced Excel Features for Freeze Panes. If you wanted to freeze everything after your first column header (down the left side basically) it would look like this:
or if you wanted to freeze everything below your header you could do something like this below own of your fields:
If you download the JasperReports zip, there is a demo folder in it, that contains this working example, in the xlsfeatures folder. As a final not, the demo worked for me when exporting to xls, but not when I tried to use xlsx (although there may be a way to make it work, I could not find anything quickly).