Hi everyone;
How can I convert excel data to an HTML table?
Hi,
What did you try?
Have a look at the node-red-contrib-spreadsheet-in node.
Play with it in combination with something like node-red-contrib-jsontohtml.
And with some effort you will succeed .
1 Like
Is that a File In node you are reading it with? Have you used a debug node to see what it looks like coming out of the file? Is it JSON?
An xls file is a binary format. You cannot simply read the file data and send it to a JSON node. It just won't work.
To confirm what I am saying, use a debug node as @Colin suggests.
Did you try the suggestions by @edje11?
1 Like
its in the flows library - same as the first link
You have to read the spreadsheet first, using a node that understand Excel, which is what the first link was for.
Not much point feeding it into a JSON node then!
Oh yeah, my bad ..I used node-red-contrib-spreadsheet-in package then "tableify" node and it's working..
Thank you @Colin & @Steve-Mcl & @edje11
1 Like
Here is my flow of others who need an example
[{"id":"9d4b3531.391338","type":"inject","z":"b00215d0.601ab8","name":"","repeat":"","crontab":"","once":false,"topic":"","payload":"","payloadType":"str","x":70,"y":100,"wires":[["1ef482ff.54be1d"]]},{"id":"1ef482ff.54be1d","type":"file in","z":"b00215d0.601ab8","name":"read a spreadsheet file as binary buffer","filename":"file_example_XLS_10.xls","format":"","chunk":false,"sendError":false,"x":310,"y":100,"wires":[["58da0822.79c4a8"]]},{"id":"58da0822.79c4a8","type":"book","z":"b00215d0.601ab8","name":"","x":270,"y":160,"wires":[["ed8b8fb2.0d17c"]]},{"id":"ed8b8fb2.0d17c","type":"sheet","z":"b00215d0.601ab8","name":"","sheetName":"Sheet1","x":330,"y":200,"wires":[["9c0ed110.bc235"]]},{"id":"9c0ed110.bc235","type":"sheet-to-json","z":"b00215d0.601ab8","name":"","raw":"false","range":"","header":"A","blankrows":true,"x":430,"y":240,"wires":[["3870180.425bde8"]]},{"id":"2dad414b.f976fe","type":"e-mail","z":"b00215d0.601ab8","server":"smtp.gmail.com","port":"465","secure":true,"tls":true,"name":"","dname":"Email","x":670,"y":260,"wires":[]},{"id":"3870180.425bde8","type":"tableify","z":"b00215d0.601ab8","name":"","before":"","after":"","tableStyle":"","theadStyle":"","tbodyStyle":"","trStyle":"","tdStyle":"","x":500,"y":280,"wires":[["2dad414b.f976fe","9480b253.bcdbd"]]},{"id":"9480b253.bcdbd","type":"debug","z":"b00215d0.601ab8","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":690,"y":320,"wires":[]}]
1 Like
This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.
