hide footer in excel export

[chiara]

Hi,
we want to save report in excel without print footer, but we need footer when we save pdf file.
How can we do?

Thanks

[Alex K.]

Hello,

Can you please describe your task in more details.

Thank you.

[chiara]

Hi,
We have uploaded a sample file.
In the excel file page's header,table's header and footer are duplicated(see sheet now).
We would like to have an excel file with a single table with all data(see sheet report)
We would like the pdf file with the current structure
Thanks

[Alex K.]

Hello,

Please try to use the "Use One Page Header and Footer" option for the Excel exprot.

Thank you.

[chiara]

Thanks!
In italian translation there is "Use header and footer for all pages"
Can we set this option by code?

Thanks

[Alex K.]

Hello,

You can use the following code:

Code: Select all

StiExcel2007ExportSettings es = new StiExcel2007ExportSettings();
es.UseOnePageHeaderAndFooter = true;
report.ExportDocument(StiExportFormat.Excel2007, "path", es);

Thank you.