hide footer in excel export
hide footer in excel export
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
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
Hello,
Can you please describe your task in more details.
Thank you.
Can you please describe your task in more details.
Thank you.
Re: hide footer in excel export
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
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
- Attachments
-
- Report.zip
- (15.45 KiB) Downloaded 207 times
Re: hide footer in excel export
Hello,
Please try to use the "Use One Page Header and Footer" option for the Excel exprot.
Thank you.
Please try to use the "Use One Page Header and Footer" option for the Excel exprot.
Thank you.
- Attachments
-
- Capture.PNG (37.52 KiB) Viewed 2512 times
Re: hide footer in excel export
Thanks!
In italian translation there is "Use header and footer for all pages"
Can we set this option by code?
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
Hello,
You can use the following code:
Thank you.
You can use the following code:
Code: Select all
StiExcel2007ExportSettings es = new StiExcel2007ExportSettings();
es.UseOnePageHeaderAndFooter = true;
report.ExportDocument(StiExportFormat.Excel2007, "path", es);