When the non-native Excel page header and footer are used (the UseNativePageHeader and UseNativePageFooter XLSX options are set to False) and the SplitWorksheetOnPageBreak property is set to True, the page header section of the report is rendered only on the first sheet, while the page footer section of the report is rendered only on the last sheet.
All Excel sheets should have the page sections present.