How can I import Excel file into Jira and then update the custom field from first row of excel

[Vaishali Pareek]

Hi All,
I need your help guys,

I am facing issue I am mentioning the issue below are the points:-

1-how to write the script to upload the excel file in to JIRA

2-how to read the xlsx file and one column.

3- how to update the CustomField Value Type in JIRA issue.

I am requesting you all in this community, I am new into JIRA and I got this task from my manager, Please help me immediately and I installed the Script Runner, but no clue how to do it

Please help me out :)

[Ravi Sagar _Sparxsys_ · Accepted solution]

Hi @Vaishali Pareek 

Can you please elaborate your use case? What is in the Excel sheet?

Since you are on cloud my recommendation would be to use Jira REST API. You can create a VBA macro to update data from Excel to your Jira Cloud.

Ravi