Use One Page Header and Footer

 

When exporting to Excel then all report is converted in one table. Headers and footers of a page break this table. This property leaves only the first header and the last header of a page. All other headers and footers are removed. If it is necessary to save the initial view of a document then it is necessary to set this property to false. For each type of exports their own property is used.