Remove header and footer from Excel export
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Background
Certain programs that extract data from Excel require JIRA's Excel export to be trimmed to only include the table of issues. (The header and footer is not required)
Example output:
Environment
Jira Data Center
Resolution
Stop JIRA.
Go to the following folder location:
$JIRA_INSTALL/atlassian-jira/WEB-INF/classes/templates/plugins/searchrequestviewsOpen searchrequest-excel-header.vm, and comment out the following parts:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19<!-- <table border="1"> <tr bgcolor="$topBgColour" height="$jiraLogoHeight"> <td colspan="$colCount"> <img src="$jiraLogo" width="$jiraLogoWidth" height="$jiraLogoHeight" border="0" alt="$title"> </td> </tr> <tr> <td colspan="$colCount"> <a href="$link">$title</a> </td> </tr> <tr> <td colspan="$colCount"> $resultsDescription </td> </tr> </table> -->This removes the top header rows.
To remove the footer, open searchrequest-excel-footer.vm and comment out the following parts:
1 2 3 4 5 6 7 8 9<!-- <table border="1" > <tr> <td bgcolor="#dddddd" colspan="$colCount"><font size="1"> $generatedInfo </font></td> </tr> </table> -->ℹ️ To "comment out" a part in the HTML code is to add <!-- and --> to enclose the code block, as per demonstrated above. This means that the interpreter will skip this part of the code. (Its the same thing as removing it directly)
Restart JIRA for the changes to take effect.
Was this helpful?