# Excel and Nodered

**URL:** <https://discourse.nodered.org/t/excel-and-nodered/16707>\
**Category:** General\
**Created:** [14 October 2019 20:55 UTC](https://discourse.nodered.org/t/excel-and-nodered/16707 "2019-10-14T20:55:01Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![ricardokemp](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ricardokemp/32/743_2.png) [@ricardokemp](https://discourse.nodered.org/u/ricardokemp)\
**Post date:** [14 October 2019 20:55 UTC](https://discourse.nodered.org/t/excel-and-nodered/16707/1 "2019-10-14T20:55:01Z")

</div>

Hello  
Please, have any resource in Nodered to work with "recipes" ?  
For exemple, if I have one Excel with 6 Colums (A to F), and 6 lines

Depending on the recipe selected, nodered already extracts the cell values ​​I need

---

<div class="post-metadata">

**Author:** ![miker256](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/miker256/32/13042_2.png) [@miker256](https://discourse.nodered.org/u/miker256)\
**Post date:** [14 October 2019 20:59 UTC](https://discourse.nodered.org/t/excel-and-nodered/16707/2 "2019-10-14T20:59:25Z")

</div>

> **[node-red-contrib-spreadsheet-in](https://flows.nodered.org/node/node-red-contrib-spreadsheet-in)**
>
> This package provides Node-RED nodes to read data from spreadsheet (Excel, ODS, etc.) file.

> **[node-red-contrib-excel](https://flows.nodered.org/node/node-red-contrib-excel)**
>
> Converts JSON to excel and writes to file specified.

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [14 October 2019 21:08 UTC](https://discourse.nodered.org/t/excel-and-nodered/16707/3 "2019-10-14T21:08:48Z")

</div>

While this isn't the answer you were looking for, have you considered using dashboard and providing users a web based recipe manager?

With flow storage (or even better a database) you could make a very nice frontend in very little time.

Even better, if you intend on sending this data directly to a PLC or some other automation system, you could initiate that from node red dashboard too.

Food for thought I hope. Otherwise discard.

---

<div class="post-metadata">

**Author:** ![ricardokemp](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ricardokemp/32/743_2.png) [@ricardokemp](https://discourse.nodered.org/u/ricardokemp)\
**Post date:** [14 October 2019 23:53 UTC](https://discourse.nodered.org/t/excel-and-nodered/16707/4 "2019-10-14T23:53:14Z")

</div>

Hello Steve, thank you  
Just to explain better, the SO of my PLC is Linux; but on IEC61131 I not have one CSV reader  
Then now my idea is create one script on Nodered (withouth dashboard)  
The idea is : The customer just paste one CSV file in one folder, then by the PLC application the user (From HMI) types the number of the recipe (ex :3); Than runs the script  
The script on Nodered needs read this value (maybe from OPC UA) then use this index to "search" this line; then the values on this line is transmitted back to the PLC (OPC UA)

---

<div class="post-metadata">

**Author:** ![kuema](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/kuema/32/6542_2.png) [@kuema](https://discourse.nodered.org/u/kuema)\
**Post date:** [15 October 2019 04:48 UTC](https://discourse.nodered.org/t/excel-and-nodered/16707/5 "2019-10-15T04:48:53Z")

</div>

Before mixing in complex technologies like OPC-UA, I would suggest you start with a working prototype using the tools you have, first. 😉

---

<div class="post-metadata">

**Author:** ![ricardokemp](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ricardokemp/32/743_2.png) [@ricardokemp](https://discourse.nodered.org/u/ricardokemp)\
**Post date:** [15 October 2019 11:09 UTC](https://discourse.nodered.org/t/excel-and-nodered/16707/6 "2019-10-15T11:09:58Z")

</div>

Hello Kuema  
OPC UA its not the problem, I just searching how I can extract on specific line into a 2D array