Remove header and footer from Excel export

Still need help?

The Atlassian Community is here for you.

Ask the community

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:

 

Resolution

  • Stop JIRA.
  • Go to the following folder location: $JIRA_INSTALL/atlassian-jira/WEB-INF/classes/templates/plugins/searchrequestviews

  • Open searchrequest-excel-header.vm, and comment out the following parts:

    <!--    
    <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:

    <!--
    <table border="1" >
    <tr>
        <td bgcolor="#dddddd" colspan="$colCount"><font size="1">
            $generatedInfo
        </font></td>
    </tr>
    </table>
    -->

    (info) 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.

Last modified on Feb 26, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.