# Unable to open excel sheet create by nodered

**URL:** <https://discourse.nodered.org/t/unable-to-open-excel-sheet-create-by-nodered/39748>\
**Category:** General\
**Created:** [26 January 2021 02:10 UTC](https://discourse.nodered.org/t/unable-to-open-excel-sheet-create-by-nodered/39748 "2021-01-26T02:10:33Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![sam\_r](https://avatars.discourse-cdn.com/v4/letter/s/0ea827/32.png) [@sam\_r](https://discourse.nodered.org/u/sam_r)\
**Post date:** [26 January 2021 02:10 UTC](https://discourse.nodered.org/t/unable-to-open-excel-sheet-create-by-nodered/39748/1 "2021-01-26T02:10:34Z")

</div>

Hello experts .. I am in a need of your guidance.  
I created a simple flow by which i get the temperature data via MQTT broker and need to keep these data in excel file.. I create the flow and also implement the debug node to see whether the flow is ok or not.. it looks ok to me and file is also created in designated address but when i open the file it popups some alert and the the file show empty..

Here is a flow .. Can anyone guide me what's happening ?

```auto
[{"id":"3ee1387d.a79638","type":"tab","label":"Flow 1","disabled":false,"info":""},{"id":"c7eb1b2.296a5e8","type":"mqtt in","z":"3ee1387d.a79638","name":"Motor Front Temperature","topic":"motor/fronttemperature","qos":"2","datatype":"auto","broker":"313d9abb.3bd086","x":110,"y":100,"wires":[["e198740f.e5aa98","2ce63582.d427aa","88a1888c.36bdd8"]]},{"id":"e198740f.e5aa98","type":"ui_chart","z":"3ee1387d.a79638","name":"Motor Front Temp","group":"e3c6e812.f530f8","order":3,"width":19,"height":5,"label":"Motor Front Temperature","chartType":"line","legend":"false","xformat":"D/M HH:mm","interpolate":"linear","nodata":"","dot":false,"ymin":"0","ymax":"80","removeOlder":"1","removeOlderPoints":"","removeOlderUnit":"3600","cutout":0,"useOneColor":false,"useUTC":false,"colors":["#1f77b4","#aec7e8","#ff7f0e","#2ca02c","#98df8a","#d62728","#ff9896","#9467bd","#c5b0d5"],"outputs":1,"useDifferentColor":false,"x":330,"y":60,"wires":[[]]},{"id":"2ce63582.d427aa","type":"ui_gauge","z":"3ee1387d.a79638","name":"Motor Front Temp","group":"e3c6e812.f530f8","order":1,"width":6,"height":5,"gtype":"gage","title":"Motor Front Tempeature","label":"oC","format":"{{value}}","min":"0","max":"80","colors":["#00b500","#e6e600","#ca3838"],"seg1":"40","seg2":"50","x":370,"y":100,"wires":[]},{"id":"88a1888c.36bdd8","type":"function","z":"3ee1387d.a79638","name":"Data","func":"var temperature = msg.payload\nvar d = new Date();\nvar t = d.toLocaleTimeString();\nvar m ={\"Time\" : t,\"Temperature\" :temperature};\nreturn {payload:m};\n","outputs":1,"noerr":0,"initialize":"","finalize":"","x":310,"y":140,"wires":[["635f545.ddfe9ac"]]},{"id":"635f545.ddfe9ac","type":"csv","z":"3ee1387d.a79638","name":"","sep":",","hdrin":true,"hdrout":"none","multi":"one","ret":"\\n","temp":"Time,Temperature","skip":"0","strings":true,"include_empty_strings":"","include_null_values":"","x":450,"y":140,"wires":[["febe10e0.5596b","d78b5c5e.29ffa"]]},{"id":"febe10e0.5596b","type":"file","z":"3ee1387d.a79638","name":"","filename":"D:\\Temperature\\temperature.xlsx","appendNewline":true,"createDir":false,"overwriteFile":"false","encoding":"none","x":680,"y":140,"wires":[[]]},{"id":"d78b5c5e.29ffa","type":"debug","z":"3ee1387d.a79638","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","statusVal":"","statusType":"auto","x":700,"y":200,"wires":[]},{"id":"313d9abb.3bd086","type":"mqtt-broker","name":"mylaptop","broker":"192.168.12.140","port":"1883","clientid":"","usetls":false,"compatmode":false,"keepalive":"60","cleansession":true,"birthTopic":"","birthQos":"0","birthPayload":"","closeTopic":"","closeQos":"0","closePayload":"","willTopic":"","willQos":"0","willPayload":""},{"id":"e3c6e812.f530f8","type":"ui_group","name":"Blower 1","tab":"9de879d7.266968","order":1,"disp":true,"width":30,"collapse":false},{"id":"9de879d7.266968","type":"ui_tab","name":"Artos 3","icon":"dashboard","order":2,"disabled":false,"hidden":false}]

```

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [26 January 2021 02:47 UTC](https://discourse.nodered.org/t/unable-to-open-excel-sheet-create-by-nodered/39748/2 "2021-01-26T02:47:20Z")

</div>

> [@sam\_r](#):
>
> when i open the file it popups some alert and the the file show empty..

Are you opening the file that gets created with the file-out node? What are you opening it with? Shouldn’t you naming the file with an extension of `csv?

---

<div class="post-metadata">

**Author:** ![sam\_r](https://avatars.discourse-cdn.com/v4/letter/s/0ea827/32.png) [@sam\_r](https://discourse.nodered.org/u/sam_r)\
**Post date:** [26 January 2021 06:15 UTC](https://discourse.nodered.org/t/unable-to-open-excel-sheet-create-by-nodered/39748/3 "2021-01-26T06:15:26Z")

</div>

Sir I am just double clicking the excel file in the folder .. Is there any specific way to open created file ?

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [26 January 2021 07:24 UTC](https://discourse.nodered.org/t/unable-to-open-excel-sheet-create-by-nodered/39748/4 "2021-01-26T07:24:29Z")

</div>

Try changing the file name so it ends with ‘csv’

---

<div class="post-metadata">

**Author:** ![sam\_r](https://avatars.discourse-cdn.com/v4/letter/s/0ea827/32.png) [@sam\_r](https://discourse.nodered.org/u/sam_r)\
**Post date:** [26 January 2021 08:37 UTC](https://discourse.nodered.org/t/unable-to-open-excel-sheet-create-by-nodered/39748/5 "2021-01-26T08:37:55Z")

</div>

Thanks it works.

---

<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:** [9 February 2021 08:38 UTC](https://discourse.nodered.org/t/unable-to-open-excel-sheet-create-by-nodered/39748/6 "2021-02-09T08:38:06Z")

</div>

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