Forums

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

How to read specific excel cells to custom fields Jira DC

Furlong_ Andrew July 10, 2024

^ Title. If I have an excel template being used as a form how can I read information from specific cells and store this in custom fields on my issue? The excel document will be stored as an attachment on the issue. Thanks!

3 answers

0 votes
Nicolas Grossi
Banned
July 10, 2024

@Furlong_ Andrew I'm not an expert on script-runner, sorry.

0 votes
Nicolas Grossi
Banned
July 10, 2024

@Furlong_ Andrew "convert" the excel to a CSV file and then import into jira, jira will ask you to map columns in CVS to jira Fields later

Furlong_ Andrew July 10, 2024

Hi @Nicolas Grossi thank you! I do have a few complications with this though as I am not be able to convert excel to CSV, this is a static form I receive. Would I be able to utilize scriptrunner to read the excel attachment and pull the desired information?

0 votes
Nicolas Grossi
Banned
July 10, 2024

@Furlong_ Andrew You want to import data from excel to JIRA ?

 

Nicolas

Furlong_ Andrew July 10, 2024

@Nicolas Grossi Yes, I'd like to import data from an attached excel document to Jira

Suggest an answer

Log in or Sign up to answer