Display Header in first page and footer in Last page in Excel

[AnthonyJ]

Hello,

I have a multipage report where I want to download in excel and do the following :-

1. Display the report in one sheet -this can be accomplished by singleXLS download. However,
are there other workarounds beside using the singleXLS download, since the singleXLS download do not
display the logo in the report.

2. Display the header in first page only.

3. Display the footer in last page only.

For 2 and 3,  I tried creating a boolean variable and use that as my style variable and changing the Box Type to None. But the header/footer either displays in all pages, or do not display at all.

Any help is appreciated.

Thanks.