Page 1 of 1
hide footer in excel export
Posted: Tue Sep 09, 2014 9:05 am
by 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
Re: hide footer in excel export
Posted: Tue Sep 09, 2014 1:13 pm
by Alex K.
Hello,
Can you please describe your task in more details.
Thank you.
Re: hide footer in excel export
Posted: Wed Sep 10, 2014 7:41 am
by 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
Re: hide footer in excel export
Posted: Wed Sep 10, 2014 12:01 pm
by Alex K.
Hello,
Please try to use the "Use One Page Header and Footer" option for the Excel exprot.
Thank you.
Re: hide footer in excel export
Posted: Wed Sep 10, 2014 12:11 pm
by chiara
Thanks!
In italian translation there is "Use header and footer for all pages"
Can we set this option by code?
Thanks
Re: hide footer in excel export
Posted: Wed Sep 10, 2014 12:55 pm
by 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.