Tips for Exporting to Excel in How-To Posted March 12, 2021 Great write up - very clear. I am trying to adapt another users custom properties as follows but not getting correct results. Any ideas? Many thanks.from https://community.jaspersoft.com/wiki/how-can-i-suppress-page-headers-and-footers-when-exporting-xlsIf you want to remove page headers and page footers, but keep the first page header in place (useful when all pages are exported to the same sheet, in a flow layout) the following properties have to be used in the report template:<property name="net.sf.jasperreports.export.xls.exclude.origin.keep.first.band.1" value="pageHeader"/><property name="net.sf.jasperreports.export.xls.exclude.origin.band.2" value="pageFooter"/>Jim
Tips for Exporting to Excel
in How-To
Posted
Great write up - very clear. I am trying to adapt another users custom properties as follows but not getting correct results. Any ideas? Many thanks.
from https://community.jaspersoft.com/wiki/how-can-i-suppress-page-headers-and-footers-when-exporting-xls
If you want to remove page headers and page footers, but keep the first page header in place (useful when all pages are exported to the same sheet, in a flow layout) the following properties have to be used in the report template:
Jim