How can I generate formatted reports from JIRA ?

Question

Hello,

My current workflow is;

1. Download an excel report from JIRA

2. Remove the columns I don't need, format it in font and colors as needed

3. Copy and paste it into PowerPoint.

I am looking for something (if available) that can;

1. Automatically generate the excel file (daily basis)

2. Format the spread sheet into the results, font, color etc that I want

Thank you.

Brant Schroeder · Accepted Answer

Ravi,

There are several different ways to do this programmatically but you would basically be creating your own one off application to extract and format the data.  I also believe that there are several plugins that allow you to export data using an automation.  You can also schedule filters but you would have to complete the formating. https://confluence.atlassian.com/jiracoreserver073/working-with-search-results-861257284.html?_ga=2.180806503.1582973740.1540224944-2113539291.1540224944

Or you can purchase add-ons like this one: Better Excel Automation for JIRA (server only