Input row from Excel spreadsheet

General
1

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?

2

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.
3

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

4

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