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

Post about your customizations to share with others.

Moderators: Contributor, Developer

Post Reply
gabrielmoreno
Posts: 2
Joined: May 01, 2018 5:09 pm

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

Post by gabrielmoreno » May 01, 2018 5:35 pm

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
Attachments
excel_report.png
excel_report.png (74.88 KiB) Viewed 931 times
Excel_.jpg
Excel_.jpg (90.02 KiB) Viewed 977 times

farandsoft
Posts: 1
Joined: Jan 31, 2018 3:48 am
Location: Barcelona
Contact:

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

Post by farandsoft » May 16, 2018 10:45 am

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.
Especialistas en aplicaciones móviles y software de gestión empresarial para PYMES como herramientas comerciales y de control.

jsonr
Posts: 3
Joined: Apr 24, 2018 7:59 pm

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

Post by jsonr » May 19, 2018 1:28 am

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.

Post Reply