# Reading excel file on raspberry pi

**URL:** <https://discourse.nodered.org/t/reading-excel-file-on-raspberry-pi/41809>\
**Category:** General\
**Created:** [1 March 2021 13:14 UTC](https://discourse.nodered.org/t/reading-excel-file-on-raspberry-pi/41809 "2021-03-01T13:14:02Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bradley](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bradley/32/37868_2.png) [@Bradley](https://discourse.nodered.org/u/Bradley)\
**Post date:** [1 March 2021 13:14 UTC](https://discourse.nodered.org/t/reading-excel-file-on-raspberry-pi/41809/1 "2021-03-01T13:14:02Z")

</div>

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.

```auto
[{"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

 ![afbeelding](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/1/91eece6dfc0d04265e603183d7eb4e131388a572.png)

---

<div class="post-metadata">

**Author:** ![edje11](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/edje11/32/572_2.png) [@edje11](https://discourse.nodered.org/u/edje11)\
**Post date:** [1 March 2021 13:21 UTC](https://discourse.nodered.org/t/reading-excel-file-on-raspberry-pi/41809/2 "2021-03-01T13:21:02Z")

</div>

'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.

---

<div class="post-metadata">

**Author:** ![Bradley](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bradley/32/37868_2.png) [@Bradley](https://discourse.nodered.org/u/Bradley)\
**Post date:** [1 March 2021 13:36 UTC](https://discourse.nodered.org/t/reading-excel-file-on-raspberry-pi/41809/3 "2021-03-01T13:36:02Z")

</div>

![afbeelding](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/e/fe22f06b472800bba5f631ed2465b09838b3d700.png)  
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.

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [1 March 2021 13:49 UTC](https://discourse.nodered.org/t/reading-excel-file-on-raspberry-pi/41809/4 "2021-03-01T13:49:06Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Bradley](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bradley/32/37868_2.png) [@Bradley](https://discourse.nodered.org/u/Bradley)\
**Post date:** [1 March 2021 13:53 UTC](https://discourse.nodered.org/t/reading-excel-file-on-raspberry-pi/41809/5 "2021-03-01T13:53:22Z")

</div>

![afbeelding](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/d/c/dcfc2a2eabc4a71504f2c8bbc61ac410f2add17f.png)  
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

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [1 March 2021 14:00 UTC](https://discourse.nodered.org/t/reading-excel-file-on-raspberry-pi/41809/6 "2021-03-01T14:00:20Z")

</div>

> [@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`

---

<div class="post-metadata">

**Author:** ![Bradley](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bradley/32/37868_2.png) [@Bradley](https://discourse.nodered.org/u/Bradley)\
**Post date:** [1 March 2021 14:02 UTC](https://discourse.nodered.org/t/reading-excel-file-on-raspberry-pi/41809/7 "2021-03-01T14:02:12Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [1 March 2021 14:03 UTC](https://discourse.nodered.org/t/reading-excel-file-on-raspberry-pi/41809/8 "2021-03-01T14:03:02Z")

</div>

So is it working now?

---

<div class="post-metadata">

**Author:** ![Bradley](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bradley/32/37868_2.png) [@Bradley](https://discourse.nodered.org/u/Bradley)\
**Post date:** [1 March 2021 14:06 UTC](https://discourse.nodered.org/t/reading-excel-file-on-raspberry-pi/41809/9 "2021-03-01T14:06:27Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [1 March 2021 14:09 UTC](https://discourse.nodered.org/t/reading-excel-file-on-raspberry-pi/41809/10 "2021-03-01T14:09:37Z")

</div>

Can you post the current flow please.

---

<div class="post-metadata">

**Author:** ![Bradley](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bradley/32/37868_2.png) [@Bradley](https://discourse.nodered.org/u/Bradley)\
**Post date:** [1 March 2021 14:10 UTC](https://discourse.nodered.org/t/reading-excel-file-on-raspberry-pi/41809/11 "2021-03-01T14:10:55Z")

</div>

Here is the flow it is a test flow

```auto
[{"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"]]}]

```

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [1 March 2021 14:31 UTC](https://discourse.nodered.org/t/reading-excel-file-on-raspberry-pi/41809/12 "2021-03-01T14:31:06Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Bradley](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bradley/32/37868_2.png) [@Bradley](https://discourse.nodered.org/u/Bradley)\
**Post date:** [1 March 2021 14:39 UTC](https://discourse.nodered.org/t/reading-excel-file-on-raspberry-pi/41809/13 "2021-03-01T14:39:14Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [1 March 2021 15:41 UTC](https://discourse.nodered.org/t/reading-excel-file-on-raspberry-pi/41809/14 "2021-03-01T15:41:51Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [15 March 2021 15:42 UTC](https://discourse.nodered.org/t/reading-excel-file-on-raspberry-pi/41809/15 "2021-03-15T15:42:49Z")

</div>

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