# How create a recipe used igintion

**URL:** <https://forum.inductiveautomation.com/t/how-create-a-recipe-used-igintion/77517>\
**Category:** Ignition\
**Created:** [August 7, 2023, 1:35pm UTC](https://forum.inductiveautomation.com/t/how-create-a-recipe-used-igintion/77517 "2023-08-07T13:35:26Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [August 7, 2023, 1:53pm UTC](https://forum.inductiveautomation.com/t/how-create-a-recipe-used-igintion/77517/5 "2023-08-07T13:53:23Z")

</div>

> [@nabil\_hocini](#):
>
> I need to create it from the Excel sheet

What have you tried? We don't know what shape any of your information takes.

What does "create" mean to you?

I would recommend that you try something and then come back with what you tried and what went wrong.

Perhaps start here:

> [@Copying an Excel file to a table's dataset](https://forum.inductiveautomation.com/t/copying-a-excel-file-to-a-tables-dataset/34942/7):
>
> The [Apache POI](https://poi.apache.org/apidocs/4.1/index.html) libraries are included with Ignition. At the time I was only needing to read files, so xlrd was all that was necessary. I'm just starting to dig into POI, myself, but here's a start: EDIT 2021-08-23: Updated to allow JsonDataSets. Changed to allow for a ByteArray output instead of writing to a file. EDIT 2023-01-20: Added option for date formats. Default is 'yyyy-MM-dd hh:mm:ss'. EDIT 2023-05-12: Added options for first row and column, if needed to offset from A1 def datasetT…

---

_[View the full topic](https://forum.inductiveautomation.com/t/how-create-a-recipe-used-igintion/77517)._
