Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Import to Excel at a Cell Level

JD Lobue
Contributor
August 31, 2021

I'm wanting to import JQL data into specific cells within MS Excel. Is this possible? I know I can import data from Jira using the cloud connecter, but that appears to import data into the entire sheet. I just want to have certain JQL values pulled into specific cells within Excel.

2 answers

0 votes
Aron Gombas _Midori_
Community Champion
November 15, 2021

The Better Excel Exporter app offers much more flexibility than the Excel connector. You can run scripts that can run JQL, process its result and insert that to a given cell.

Your use case sounds totally doable, but if you tell me more about the concrete details, I should be able to give you more guidance how to implement with the app!

(Discl. I'm a developer working on this paid and supported app.)

0 votes
Mohamed Benziane
Community Champion
September 1, 2021

Hi,

you can try to import all data you need like you already do and create some function to extract the values you want into an other sheet in the same file.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events