Nice to be in this community！ I can't append after using excelsheets to create excel, I can only cover; If multiple sheets cannot be created using CSV; I need to put the data of 2 devices into a file, each device corresponds to a piece of paper to record the data [ { "id": "81e91fe52…

[ { "id": "81e91fe521078ee2", "type": "tab", "label": "临时测试", "disabled": false, "info": "", "env": [] }, { "id": "1502ffe3922a84f9", "type": "inject", "z": "81e91fe521078ee2", "name": "", "props": [ …

hi smanjunath211 Can this be reproduced now? I am a novice thanks

[image] BG6WCL: excelsheets Welcome to the forum. It helps to provide a reference to specific nodes you might be using. In this case: node-red-contrib-excelsheets (node) - Node-RED (nodered.org) . (There are thousands of nodes now at it is often hard to know what people are using). So can yo…

And I am sorry, I think Google translate is not at its best here, please confirm if I am reading your problem right. You are able to create an excel file (I did using your flow), but you don't know how to append your file with new data. That is add new data at the end of file. I could not understan…

hi smanjunat. Thank you for your reply, your understanding is correct, the current excel is unable to add data I need to append data in excel, and when I reinject the data before excel is overwritten

Think you reply. When I reinject the data before excel is overwritten

I did a little research and found this answer by @TotallyInformation who is also seeing this thread. may be he has some more inputs. sorry I could not help. [image] Saving a JSON array in an excel file General You will need to rearrange the JSON somewhat. Firstly, if you…

Unfortunately, this is a different node as far as I can tell from what has been shared. The node doesn't have a lot of documentation so I think an issue will need to be raised in GitHub to find an answer. Or maybe use the excel node instead?

Can excel node create two sheets? He wants two separate worksheets to be updated for two inputs.

Problems with creating CSV or excel

General

smanjunath211 22 January 2022 09:22 2

Please use the below guide to post code in preformatted text, so that it is easy to copy your code.

howtopastecode

Educating my self - some guidance asked

Power measurement only if the load is ON!

Topic		Replies	Views
Need help in writing Multiple message outputs to a columns in single excel file General	2	534	11 November 2019
I am having trouble opening excel files when using the Excel Sheets node General	9	776	2 December 2021
Email with csv attachment. Open with Excel General	5	862	17 June 2021
Write data from 2 directions in different columns of csv file General	32	600	22 July 2022
Excel file node General node-red-contrib-excel	2	330	24 May 2023

Problems with creating CSV or excel

Related topics