Live excel of Jira data

[Kaj Sennelöv]

Hi community!

I have an excel that does a few calculations etc on Jira data from two projects.
Currently, I am manually importing the Jira data with the Jira cloud for excel addon.

In an ideal scenario, this excel is updated automatically every X minutes. Is there a way to automate this through Jira, excel, or Ms power?

Looking forward to your thoughts!

Greetings, 

-Kaj

[Fabio Racobaldo _Herzum_]

Hi @Kaj Sennelöv ,

you should use REST API provided by Atlassian JIRA in order to download data on your excel file and then perform all the calculation you want.

I did it for a customer using https://www.codeproject.com/Articles/1088523/Excel-Jira-Rest-API-end-to-end-example

Hope this helps,

Fabio

[Kaj Sennelöv]

Hi @Fabio Racobaldo _Herzum_ 

Thank you for the tip!
This is a little above my current knowledge, but I like the challenge. ;)

Will give it a try one of these days.

Thanks again!
-Kaj

[Hannes Obweger - JXL for Jira]

Hi @Kaj Sennelöv

for a completely different path: May I ask which kind of calculations you are performing in Excel?

I'm asking because there's a number of apps in the Marketplace - our own app, JXL for Jira, being one of them - that bring many spreadsheet capabilities directly to Jira. This means that you always operate on "live" Jira data, and don't even have to worry about an export, let alone keeping this export up to date.

I'm happy to elaborate more if you're interested, but whether it makes sense or not really depends on your use case.

Best,

H

[Kaj Sennelöv]

Hi @Hannes Obweger - JXL for Jira

We are using the excel for a Gecko board which will also use other integrations.
Hence we are tied to that excel.

 Thanks for the tip though,

-Kaj