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…

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

[ { "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.

Node-RED

Node-RED Forum

Problems with creating CSV or excel

General

smanjunath211 23 January 2022 03:59 9

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.

Topic		Replies	Views
Need help in writing Multiple message outputs to a columns in single excel file General	2	531	11 November 2019
I am having trouble opening excel files when using the Excel Sheets node General	10	767	31 January 2022
Email with csv attachment. Open with Excel General	6	858	1 July 2021
Write data from 2 directions in different columns of csv file General	33	535	20 September 2022
Excel file node General node-red-contrib-excel	3	325	23 July 2023

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.

Problems with creating CSV or excel

Related topics