How to push data to csv and excel?

General
1

Hi,

May i know how to push the data through the csv file to Excel file or just push data to Excel?

[{"id":"67e160d143a67534","type":"tab","label":"Flow 11","disabled":false,"info":"","env":[]},{"id":"9d4b3531.391338","type":"inject","z":"67e160d143a67534","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":"","topic":"","payload":"34","payloadType":"str","x":210,"y":160,"wires":[["f1e704a18d3a8635"]]},{"id":"58da0822.79c4a8","type":"book","z":"67e160d143a67534","name":"","raw":true,"x":370,"y":380,"wires":[["8bd99783.125c38","ed8b8fb2.0d17c"]]},{"id":"ed8b8fb2.0d17c","type":"sheet","z":"67e160d143a67534","name":"","sheetName":"Sheet1","x":540,"y":440,"wires":[["f0303664.0d9938","9c0ed110.bc235","fe9e8ba9.f59db8"]]},{"id":"f0303664.0d9938","type":"cell","z":"67e160d143a67534","name":"","address":"A1","dataType":"w","x":700,"y":500,"wires":[["99f7011e.3ecda"]]},{"id":"9c0ed110.bc235","type":"sheet-to-json","z":"67e160d143a67534","name":"","raw":"false","range":"A1:B2","header":"default","blankrows":false,"x":720,"y":560,"wires":[["4c28547e.6d566c"]]},{"id":"8bd99783.125c38","type":"debug","z":"67e160d143a67534","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload.SheetNames","targetType":"msg","statusVal":"","statusType":"auto","x":870,"y":380,"wires":[]},{"id":"99f7011e.3ecda","type":"debug","z":"67e160d143a67534","name":"","active":true,"console":"false","complete":"false","x":920,"y":500,"wires":[]},{"id":"4c28547e.6d566c","type":"debug","z":"67e160d143a67534","name":"","active":true,"console":"false","complete":"false","x":920,"y":560,"wires":[]},{"id":"fe9e8ba9.f59db8","type":"debug","z":"67e160d143a67534","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":920,"y":440,"wires":[]},{"id":"71fb941ffbdabba9","type":"csv","z":"67e160d143a67534","name":"","sep":",","hdrin":"","hdrout":"none","multi":"one","ret":"\\n","temp":"B1","skip":"1","strings":true,"include_empty_strings":true,"include_null_values":"","x":890,"y":140,"wires":[["58da0822.79c4a8"]]},{"id":"f1e704a18d3a8635","type":"file","z":"67e160d143a67534","name":"","filename":"\"C:\\Users\\kelvin\\OneDrive\\test.xlsx\"","filenameType":"str","appendNewline":true,"createDir":false,"overwriteFile":"false","encoding":"none","x":540,"y":60,"wires":[["71fb941ffbdabba9"]]}]
2

Hi @kelvin, could you please tell us which "excel-node" you are using?

3

Hi @rko,

i was using the "node-red-contrib-spreadsheet-in"

4

Note: I edited your first post so the flow can be imported.

In order to make code readable and usable it is necessary to surround your code with three backticks (also known as a left quote or backquote ```)

``` 
   code goes here 
```

You can edit and correct your post by clicking the pencil :pencil2: icon.

See this post for more details - How to share code or flow json

5

That is for reading a spreadsheet not writing to it.

6

I gave some suggestions on another recent thread I seem to remember.

The approach depends on a number of factors. One approach would be to avoid trying to output direct to Excel and instead output to CSV (native Node-RED nodes) and use a standard template Excel workbook that uses PowerQuery to ingest the CSV. If additional automation of the Excel side is needed, Node-RED could orchestrate that by calling out to PowerShell and using Office automation.

7

i see ok thanks

8

Hi Zenofmud,

i already edit my post and thanks.

9

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