Saving a JSON array in an excel file


#1

Currently I'm doing a project where a sensor captures the distance in relation to time. My current problem lies in saving this data to an excel table, I am currently using this node (https://flows.nodered.org/node/node-red-contrib-excel), and this is giving me the result of the image sent,tabela

It's just a value for each column, would i like to know how I can solve this problem? would require that the distance be in one column and the time in another respectively.

codigo

flow


#2

If you mean you want something like?

     distancia    temp
     10               28
     20               38
     30               48

Then I think you need to store the data together and then send it to the excel node.

Another way of achieving an excel compatible file would be to write it as csv ( comma separated file)
where you can create format each line and then add it to an existing file using the FILE-out node


#3

gonna try this, when i did i will answer you! thanks


#4

The csv node will convert well formed JSON into CSV which you can then easily save to a spreadsheet if needed.