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
How to add a Header with logo in Excel Report file (in view_all_bug_page.php)
Moderators: Developer, Contributor
-
- 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)
- Attachments
-
- excel_report.png (74.88 KiB) Viewed 6014 times
-
- Excel_.jpg (90.02 KiB) Viewed 6060 times
-
- 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)
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.
Re: How to add a Header with logo in Excel Report file (in view_all_bug_page.php)
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.
Otherwise you are stuck with post-processing, as farandsoft suggested.