Looking for Example Excel w/ VBA accessing Jira enabling access to Story Status for Metrics.

[Peter Mott]

I'm looking to build some Metrics (in Excel) but would like them to be updated directly off Jira.   Specifically, I'm looking to pull status of specific stories.  This is not on the cloud.  I'm accessing a Jira database directly.

[Dag Atle Stenstad]

Hi @Peter Mott ! Here's a VBA add-in I wrote that uses the REST API for Jira. You can use this as an example of how to authenticate.
https://github.com/dagiz007/ExcelAddin4Atlassian

[Laura Campbell]

Hi @Peter Mott and welcome to Community!

You will need an app to achieve what you are looking to do. Check out what is available on the Marketplace: https://marketplace.atlassian.com/search?query=excel&product=jira&hosting=dataCenter

You may find more success evaluating some of the reporting apps that build reports directly in Jira, as opposed to exporting data to Excel and then building the reports, but that depends on your team and processes.