JIRA.JQL() Function in Excel

Alanis_ Hans
Contributor
March 17, 2024

I'm having an issue with JIRA and Excel integration.
Here's my JQL:  =JIRA.JQL("project = 'ABC' AND key = '" & A2 & "'", "Status")

TheJQL is set in Excel cell B2. The query checks the status of a specific issue based on the issue key value defined in cell A2.
The data is being pulled correctly, however, when the results are imported into Excel, three extra data rows are added:

  • B2 - Starting Import (Taskpane should be opened) at <date/time> by <user>
  • B3 - 1 rows imported in 1 seconds
  • B4 - Status
  • B5- <Status Value>

As you can see, the Status value is moved to cell B5 instead of staying in B2.
How can I ensure that the status value always appears in cell B2, where my query is?

1 answer

0 votes
Jehan Bhathena
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 1, 2024

Hi @Alanis_ Hans 

I'm not quite sure of the integration you've mentioned, perhaps you can share a link to this integration reference, based on that we maybe able to answer your query better.

Nir Sarusy
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
October 6, 2024

As I also have the same problem, I would try to explain the problem:

We're using the Jira Cloud Plugin for Excel.

This plugin adds, among other ways, the option to use JQL in form of  Excel formula

( JIRA.JQL() ).

What @Alanis_ Hans  described is that when he placed the formula on cell B2, and the formula references to a value in cell A2, obviously, he expects that the result will appear in cell B2, as a "regular" Excel formula (the cell which contains the formula displays the formula result's value),

BUT because of the prompts " Starting Import (Taskpane should be opened) at <date/time> by <user" and other prompts that the plugin writes, the desired value appears in column B5.

I looked for a setting in the plugin that will hide the unnecessary prompts, but could find such.
My explanation came out too long, sorry for that...

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events