Page 1 of 1

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

Posted: 01 May 2018, 22:35
by gabrielmoreno
Hello friends
I'm new MantisBT user and begginer in PHP/Mysql codes, so please...be patience :D .

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

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

Posted: 16 May 2018, 15:45
by 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.

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

Posted: 19 May 2018, 06:28
by 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.