Lora to excel with nodered

Hello everybody,

I get the data of my gateway with Lora node, but now I need to save this data (temperatures) in a Excel file.
I'm using the nodes of the picture below, I've tried with and without csv node, but nothing happens and I can't save my data into the xlsx specified file.
Somebody knows If i miss something or how I can achieve it?

Thanks, Perico.
sensor

I would try just using a CSV file for now rather than messing with the complexity of .xlsx files. You can enhance later if you really need to output to a workbook.

You will need to share the data structure coming from your function node otherwise we can't see what it is like.

However, in general, you will want to end up with an array of objects to successfully convert to the tabular format needed for CSV or Excel.

[
    {
        "col1": val1,
        "col2": val2,
    },
   ....
]

At the picture below I show the coming structure of my data, my intention is to save this data in a file. In the function node I catch only the payload, because I only need it.

so the csv node expects to receive a msg.payload with and object with properties in. you function node doesn't do that ... you may need

msg.payload = msg.payload.temperature;

but we can't actually see what is really coming out of the lora node so hard to guess ... show us the debug directly connected to that.

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