Just a heads up: On March 24, 2025, starting at 4:30pm CDT / 19:30 UTC, the site will be undergoing scheduled maintenance for a few hours. During this time, the site might be unavailable for a short while. Thanks for your patience.

×
Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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