Dump to excel

Dump to excel

Posted by: darin on 19 December 2022, 1:31 pm EST

• 

  darin

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 19 December 2022, 1:31 pm EST

  I know any report can be saved into excel using the export.excel.selection report, but that saves the report format too (with page headers and footers). Is there an easy way to save to excel that are the columns that are displayed w/o the page header/footers, etc?

• 

  akshay.rajput

  

  • Post Options:
  • Link
    Copy

  Posted 20 December 2022, 7:35 am EST

  Hi Darin,

  You can hide the Page Header/Footer or any other section by setting the Visible Property to false of the section before calling the SectionReport.Run() method so the new generated report document does not have the PageHeader/Footer section. Please refer to the following lines of code:

              report.Sections["pageHeader"].Visible = false;
              report.Sections["pageFooter"].Visible = false;
              report.Run();
  

  I have attached a sample application implementing the same along with.

  Regards,

  Akshay
  
  ExcelExport.zip