Reading excel file on raspberry pi

[Bradley]

Is it possible to read a excel file in on a raspberry pi os to get data from that excel sheet or is that not possible.

I hope you guys can help me becasue i only find it for windows and anwsers for raspberry pi os.

[{"id":"d5830d92.707c1","type":"tab","label":"test rpi","disabled":false,"info":""},{"id":"62596014.67924","type":"inject","z":"d5830d92.707c1","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"str","x":90,"y":320,"wires":[["f49e35c1.2260f8","53535d29.52e524"]]},{"id":"4b11cf91.fd6","type":"debug","z":"d5830d92.707c1","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":870,"y":460,"wires":[]},{"id":"f49e35c1.2260f8","type":"file in","z":"d5830d92.707c1","name":"","filename":"\\home\\pi\\Map1.xslx","format":"utf8","chunk":false,"sendError":false,"encoding":"none","x":290,"y":260,"wires":[["5354adbb.ab5514","9ad87028.78047"]]},{"id":"9ad87028.78047","type":"book","z":"d5830d92.707c1","name":"Map1","raw":false,"x":510,"y":160,"wires":[["af96929c.8ae37"]]},{"id":"af96929c.8ae37","type":"sheet","z":"d5830d92.707c1","name":"","sheetName":"Blad1","x":650,"y":240,"wires":[["baf1cc89.68773"]]},{"id":"baf1cc89.68773","type":"cell","z":"d5830d92.707c1","name":"","address":"A1","dataType":"w","x":790,"y":320,"wires":[["4b11cf91.fd6"]]},{"id":"53535d29.52e524","type":"file","z":"d5830d92.707c1","name":"","filename":"\\home\\pi\\1.txt","appendNewline":true,"createDir":false,"overwriteFile":"false","encoding":"none","x":320,"y":400,"wires":[["4b11cf91.fd6"]]},{"id":"5354adbb.ab5514","type":"sheet-to-json","z":"d5830d92.707c1","name":"","raw":"false","range":"","header":"default","blankrows":false,"x":510,"y":300,"wires":[["4b11cf91.fd6"]]}]

This is a litlle test code and as you can see there are both out the same lib and the only differce is that one is a xslx and the other is a txt file

[edje11]

'No such file or directory' that's what you have to look at.

• Keep in mind that in Linux everything is case sensitive, so Map1 and map1 are different things.
• File property need to be set that everybody can open the file for read or maybe also writing.

Check in a terminal in the \home\pi directory with ls -la what files are there and what the permission are.

[Bradley]

I did what you said but i dont realy now what i need to do now whit that black window he sees Map1.xslx so it exist and the case is right. But is still give the same problem already thx that you help me.

I sthere something else i need to do before it works or is this a problem on rasberry pi and node red for excel files.

[Colin]

You want forward slashes not backslashes. Those are for Windows. But nowadays you don't need them for Win either, so always use forward.

[Bradley]

That is something i tried at first as you can see on the pic it doenst make a differce for the txt file but het still cant find the excel file while everything is in right place with the caps and al . But thx for the commenent

[TotallyInformation]

@Bradley

\home\pi\Map1.xslx

That is not a valid ext filing system name I don't believe, it should be /home/pi/Map1.xslx

[Bradley]

That is somthing i did see reply above but thx for the reminder it is indeed a mistake made quickly

[Colin]

So is it working now?

[Bradley]

No it still doesnt work it still says

Blockquote No such file or directory open

And then the name all maps are closes only webbrowser is standing open on the raspberry pi os

[Colin]

Can you post the current flow please.

[Bradley]

Here is the flow it is a test flow

[{"id":"d5830d92.707c1","type":"tab","label":"test rpi","disabled":false,"info":""},{"id":"62596014.67924","type":"inject","z":"d5830d92.707c1","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"str","x":90,"y":320,"wires":[["f49e35c1.2260f8","53535d29.52e524","1f9074a9.f84fdb"]]},{"id":"4b11cf91.fd6","type":"debug","z":"d5830d92.707c1","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":870,"y":460,"wires":[]},{"id":"f49e35c1.2260f8","type":"file in","z":"d5830d92.707c1","name":"","filename":"/home/pi/Map1.xslx","format":"utf8","chunk":false,"sendError":false,"encoding":"none","x":290,"y":260,"wires":[["5354adbb.ab5514","9ad87028.78047"]]},{"id":"9ad87028.78047","type":"book","z":"d5830d92.707c1","name":"Map1","raw":false,"x":510,"y":160,"wires":[["af96929c.8ae37"]]},{"id":"af96929c.8ae37","type":"sheet","z":"d5830d92.707c1","name":"","sheetName":"Blad1","x":650,"y":240,"wires":[["baf1cc89.68773"]]},{"id":"baf1cc89.68773","type":"cell","z":"d5830d92.707c1","name":"","address":"A1","dataType":"w","x":790,"y":320,"wires":[["4b11cf91.fd6"]]},{"id":"53535d29.52e524","type":"file","z":"d5830d92.707c1","name":"","filename":"\\home\\pi\\1.txt","appendNewline":true,"createDir":false,"overwriteFile":"false","encoding":"none","x":320,"y":400,"wires":[["4b11cf91.fd6"]]},{"id":"5354adbb.ab5514","type":"sheet-to-json","z":"d5830d92.707c1","name":"","raw":"false","range":"","header":"default","blankrows":false,"x":510,"y":300,"wires":[["4b11cf91.fd6"]]},{"id":"1f9074a9.f84fdb","type":"file","z":"d5830d92.707c1","name":"","filename":"/home/pi/1.txt","appendNewline":true,"createDir":false,"overwriteFile":"false","encoding":"none","x":300,"y":440,"wires":[["4b11cf91.fd6"]]}]

[Colin]

It is important to get all the x, s, and l characters in the same order in the flow and the file name.

[Bradley]

Oh i feel so stupid right now hwo did i look over that use that file a lot thx for poitning out that thx a lot for helping my dumb mistake and othere guys to for your time thank u again.

[Colin]

It has happened to us all, the brain sees what it expects, not what the eyes are telling it. It took us long enough to notice too.