Hello,
I'm brand new to Node-Red. I got most things from my themp and voltet measurements.
Now I want to start a new project. I send a request to my car and I want to automatically write it to an Excel spreadsheet at the same time every day, Date KM % Battery Remaining Battery
I've already tried something, but only one piece of information arrived in Excel and only in one line.
So I hope someone can help me to make my project fly
[{"id":"6566300f.c3f59","type":"debug","z":"7cd76bbd.117da4","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":990,"y":860,"wires":},{"id":"f705fd8.b0d16","type":"change","z":"7cd76bbd.117da4","name":"","rules":[{"t":"set","p":"ts","pt":"msg","to":"","tot":"date"},{"t":"set","p":"ts","pt":"msg","to":"$moment(ts).locale("de").tz('Europe/Berlin').format('DD.MM.YYYY HH:mm:ss')","tot":"jsonata"},{"t":"set","p":"payload","pt":"msg","to":"ts & ';' & msg.payload.data.attributes.totalMileage\t","tot":"jsonata"},{"t":"set","p":"payload","pt":"msg","to":"ts & ';' & msg.payload.data.attributes.batteryLevel\t","tot":"jsonata"},{"t":"set","p":"payload","pt":"msg","to":"ts & ';' & msg.payload.data.attributes.batteryAutonomy\t","tot":"jsonata"}],"action":"","property":"","from":"","to":"","reg":false,"x":590,"y":960,"wires":[["52b2ab1d8d89182d"]]},{"id":"eb4feda0e69229ce","type":"inject","z":"7cd76bbd.117da4","name":"battery-Level","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"battery-status","payload":"data.attributes.batteryLevel","payloadType":"str","x":90,"y":880,"wires":[["7c9baca42ac959fe"]]},{"id":"d6d81effee406b69","type":"inject","z":"7cd76bbd.117da4","name":"battery-rest","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"battery-status","payload":"data.attributes.batteryAutonomy","payloadType":"str","x":90,"y":940,"wires":[["7c9baca42ac959fe"]]},{"id":"9c899ce1e6464984","type":"inject","z":"7cd76bbd.117da4","name":"Kilometer","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"cockpit","payload":"payload.data.attributes.totalMileage","payloadType":"str","x":100,"y":1000,"wires":[["7c9baca42ac959fe"]]},{"id":"85bef2c0834b9529","type":"join","z":"7cd76bbd.117da4","name":"","mode":"custom","build":"object","property":"topic","propertyType":"msg","key":"payload","joiner":"\n","joinerType":"str","accumulate":true,"timeout":"","count":"1","reduceRight":false,"reduceExp":"","reduceInit":"","reduceInitType":"num","reduceFixup":"","x":510,"y":860,"wires":[["f705fd8.b0d16","6566300f.c3f59"]]},{"id":"7c9baca42ac959fe","type":"renault-ze","z":"7cd76bbd.117da4","name":"Dacia Spring","x":350,"y":1000,"wires":[["85bef2c0834b9529"]]},{"id":"52b2ab1d8d89182d","type":"excel","z":"7cd76bbd.117da4","name":"Auto","file":"/data/user/Auto.xlsx","x":830,"y":940,"wires":[["6566300f.c3f59"]]}]
I hop its ok , I ask the 3 Informations over API from the Car and then I want it to put it in excel in one Line and the next day in the next line and so on.
Rregards Markus
sorry for the english is not my first language