# Input row from Excel spreadsheet

**URL:** <https://discourse.nodered.org/t/input-row-from-excel-spreadsheet/73113>\
**Category:** General\
**Tags:** function-node\
**Created:** [3 January 2023 17:15 UTC](https://discourse.nodered.org/t/input-row-from-excel-spreadsheet/73113 "2023-01-03T17:15:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dpenz](https://avatars.discourse-cdn.com/v4/letter/d/48db29/32.png) [@dpenz](https://discourse.nodered.org/u/dpenz)\
**Post date:** [3 January 2023 17:15 UTC](https://discourse.nodered.org/t/input-row-from-excel-spreadsheet/73113/1 "2023-01-03T17:15:22Z")

</div>

I'm a rank newbie, having trouble with my first Node-RED project. I'm using Node-RED v.3.0.2, with node blocks from "node-red-contrib-spreadsheet-in", v.0.6.0.

The task is to input a particular row from a workbook sheet, with the input row range given in a particular cell in another sheet of the same workbook. My Flow 1 works fine to obtain the row range from the spreadsheet. Flow 2 uses the "sheet-to-JSON" function to input the row data. This flow also works fine, if I type the desired range into the "Range" field of the function block.

What does not work is when I make a global variable from the range obtained in Flow 1, and insert the variable into the "Range" field of the function block. Is there another way to do this task?

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [5 January 2023 10:48 UTC](https://discourse.nodered.org/t/input-row-from-excel-spreadsheet/73113/2 "2023-01-05T10:48:46Z")

</div>

David, welcome to the forum and sorry no one has replied yet.

It would be helpful it you provided some more information:

- an export of a small flow demonstrating our issue
- an copy of a small spreadsheet that will show the issue.

---

<div class="post-metadata">

**Author:** ![dpenz](https://avatars.discourse-cdn.com/v4/letter/d/48db29/32.png) [@dpenz](https://discourse.nodered.org/u/dpenz)\
**Post date:** [13 January 2023 00:00 UTC](https://discourse.nodered.org/t/input-row-from-excel-spreadsheet/73113/3 "2023-01-13T00:00:12Z")

</div>

Paul,

Thanks for checking on me. I came up with a work-around for the problem I had run into. So all is well now, I’m making good progress.

Regards,

Dave

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [14 March 2023 00:00 UTC](https://discourse.nodered.org/t/input-row-from-excel-spreadsheet/73113/4 "2023-03-14T00:00:27Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.