Can import location for Jira add-in Excel be changed from A1?

[Jakub Suchý]

I'm using Jira Cloud add-in for Excel. The imported data is always placed starting at cell A1. Is there a way to configure the import location so that data is imported starting from another cell (e.g. A6) and refreshed there as well?

[Duc Thang TRAN · Accepted solution]

@Jakub Suchý 

You can use function excel jira.jql on cell A6

For exemple :

=JIRA.JQL("project = Myproject ORDER BY created DESC","issuetype,priority,duedate",6000)

Hope this help :)

[Marc -Devoteam- · Accepted solution]

Hi @Jakub Suchý 

No this is not possible.

The import takes A1 as first if this is empty, then the import will fail.