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] I…

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…

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

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

i tried your method but still can't get past on a single row

I have two solutions which on are you trying? store the data and send once Use the csv node if it is 2 check that your file out node is configured to add/append data

i tried the second it doesn't create the accurate format .. as for the first one i don't really know how to build a flow that send the file all at once

What is inaccurate with the format?

Hi, I am new to node-red, can you give an example how to store the data together and send it to excel node, so that i can insert multiple rows into excel

@Ramya - Where are you getting the data from? What format is the date in? What have you tried so far? Show us your flow (read How to share code or flow json )

I am hard-coding the json data in my function node,I can able to store the array of multiple json into excel , assume i have [{"key1":"a","key2":"b"},{"key3":"c","key4" : "d"}] but now can you help me how to strore the key1 and key2 into sheet1 of excel and key3 and key4 into sheet2 of excel. now i…

Node-RED

Node-RED Forum

Saving a JSON array in an excel file

General

Topic		Replies	Views
Saving MQTT JSON data to an excel spreadsheet General	8	3616	11 March 2020
How to send data to excel General	14	10852	22 July 2019
How to push data to csv and excel? General function-node	7	404	10 January 2023
Xlsx file to json using function General function-node	4	208	7 February 2024
String delimited by comma to xlsx sheet seperated by column General	10	582	15 July 2021

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Saving a JSON array in an excel file

Related topics