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: Developer, Contributor

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

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

Post 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
Attachments
excel_report.png
excel_report.png (74.88 KiB) Viewed 5869 times
Excel_.jpg
Excel_.jpg (90.02 KiB) Viewed 5915 times
farandsoft
Posts: 1
Joined: 31 Jan 2018, 08:48
Location: Barcelona
Contact:

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

Post 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.
Especialistas en aplicaciones móviles y software de gestión empresarial para PYMES como herramientas comerciales y de control.
jsonr
Posts: 4
Joined: 25 Apr 2018, 00:59

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

Post 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.
Post Reply