How can I generate formatted reports from JIRA ?

[Ravi Shingala]

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 solution]

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

[Ravi Shingala]

Thank you!