How to add a Header with logo in Excel Report file (in view_all_bug_page.php)

[gabrielmoreno]

Hello friends
I'm new MantisBT user and begginer in PHP/Mysql codes, so please...be patience .

1 - I need to create a Excel Icon in print_all_bug_page.php file. How to do it? To create a same Excel report in excel_xml_export.php

2 - I need to customize this Excel report created. I need to add a Header with logotype, address, user login (Who create the Excel report) and other personal columms. Is it possible?

Please, see images below.

Thanks in advance

[farandsoft]

Good afternoon, to generate a Footer or an Excel header. You have to go in the top menu to the top side of the Insert-> Header and in the footer session and it will open tools for header and footer and there you add your logo header, address and everything you want to include.

[jsonr]

The built in Excel export is really very basic. For richer reports, I'd recommend to write your own plugin using PHPSpreadsheet (formerly PHPExcel). Everyone has different needs in this area, often very specific, so there isn't a good generic solution.

Otherwise you are stuck with post-processing, as farandsoft suggested.