The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Hannes Obweger - Fine Software - JXL
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
👋 Hi there Jira Community! A few months ago we shared with you plans around renaming epics in your company-managed projects. As part of these changes, we highlighted upcoming changes to epics on...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.