# From xls to Jira via Robot Framework

**URL:** https://forum.robotframework.org/t/from-xls-to-jira-via-robot-framework/5479
**Category:** Robot Framework
**Created:** [22 March 2023 13:21 UTC](https://forum.robotframework.org/t/from-xls-to-jira-via-robot-framework/5479 "2023-03-22T13:21:15Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![SuperPumpkin](https://avatars.discourse-cdn.com/v4/letter/s/e274bd/32.png) [@SuperPumpkin](https://forum.robotframework.org/u/SuperPumpkin)
#### Post date: [22 March 2023 13:21 UTC](https://forum.robotframework.org/t/from-xls-to-jira-via-robot-framework/5479/1 "2023-03-22T13:21:15Z")

</div>

Hi all,

Issue: there are bug reports in excel - I need to import it in Jira via Robot Framework.

The errors get send to e.g. a table (xls)  
That action is triggering the REST interface where a robot framework script is used  
This automation creates the ticket in jira based on the excel’s information and sends back the jira ID of the ticket into the excel

Do you have ideas of RF script for this or info how to do it?

thank you

---

<div class="post-metadata">

### Author: ![damies13](https://dub1.discourse-cdn.com/flex005/user_avatar/forum.robotframework.org/damies13/32/623_2.png) [@damies13](https://forum.robotframework.org/u/damies13)
#### Post date: [24 March 2023 04:30 UTC](https://forum.robotframework.org/t/from-xls-to-jira-via-robot-framework/5479/2 "2023-03-24T04:30:25Z")

</div>

Hi Anna,

I’ve not done that myself, but it should be possible, here’s some links that might help:

- [robotframework-datadriver](https://github.com/Snooz82/robotframework-datadriver), this Library will let you read the excel file’s data into variables. There are examples of this through out this forum
- [RequestsLibrary](https://marketsquare.github.io/robotframework-requests/doc/RequestsLibrary.html), this library will let you call the REST API’s of Jira, There are examples of doing this through out this forum as well.

Include both these libraries in your robot file, use the datadriver keywords to get the excel data into variable, then use those variable when calling Jira’s API’s with the RequestsLibrary keywords and you should be able to acheive what you need.

Dave.

---

<div class="post-metadata">

### Author: ![SuperPumpkin](https://avatars.discourse-cdn.com/v4/letter/s/e274bd/32.png) [@SuperPumpkin](https://forum.robotframework.org/u/SuperPumpkin)
#### Post date: [24 March 2023 06:47 UTC](https://forum.robotframework.org/t/from-xls-to-jira-via-robot-framework/5479/3 "2023-03-24T06:47:34Z")

</div>

thank you very much, Dave!