# Using xlsx to json node, cannot change file after being used

**URL:** <https://discourse.nodered.org/t/using-xlsx-to-json-node-cannot-change-file-after-being-used/63703>\
**Category:** General\
**Created:** [10 June 2022 02:29 UTC](https://discourse.nodered.org/t/using-xlsx-to-json-node-cannot-change-file-after-being-used/63703 "2022-06-10T02:29:06Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![MAvitia](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mavitia/32/62984_2.png) [@MAvitia](https://discourse.nodered.org/u/MAvitia)\
**Post date:** [10 June 2022 02:29 UTC](https://discourse.nodered.org/t/using-xlsx-to-json-node-cannot-change-file-after-being-used/63703/1 "2022-06-10T02:29:06Z")

</div>

I am using this fairly new node xlsx to json node, the idea of the flow is to load a file, to something with the data, and have the capability of opening a different file to repeat the process

the problem here is that once the node is used, with a certain file, for example file 1, on the next run, trying to load file 2, it will still open file 1, even when the msg.filepath input has been properly changed.

I think this is something to do with the node itself, unfortunately I cannot seem to find the place to locate the particular contributor, to provide feedback.

```auto
[
    {
        "id": "3e06b3433b7a20ad",
        "type": "tab",
        "label": "Flow 2",
        "disabled": false,
        "info": "",
        "env": []
    },
    {
        "id": "d3e2d31e4bca1883",
        "type": "inject",
        "z": "3e06b3433b7a20ad",
        "name": "",
        "props": [
            {
                "p": "payload"
            },
            {
                "p": "topic",
                "vt": "str"
            }
        ],
        "repeat": "",
        "crontab": "",
        "once": false,
        "onceDelay": 0.1,
        "topic": "",
        "payload": "",
        "payloadType": "date",
        "x": 120,
        "y": 120,
        "wires": [
            [
                "195eb091a12ec3eb"
            ]
        ]
    },
    {
        "id": "195eb091a12ec3eb",
        "type": "change",
        "z": "3e06b3433b7a20ad",
        "name": "",
        "rules": [
            {
                "t": "set",
                "p": "filepath",
                "pt": "msg",
                "to": "Procedure_filepath",
                "tot": "global"
            }
        ],
        "action": "",
        "property": "",
        "from": "",
        "to": "",
        "reg": false,
        "x": 360,
        "y": 120,
        "wires": [
            [
                "8970825e3063a997"
            ]
        ]
    },
    {
        "id": "912504b8ae2aeb06",
        "type": "change",
        "z": "3e06b3433b7a20ad",
        "name": "",
        "rules": [
            {
                "t": "set",
                "p": "Procedure_Selected",
                "pt": "global",
                "to": "payload",
                "tot": "msg"
            }
        ],
        "action": "",
        "property": "",
        "from": "",
        "to": "",
        "reg": false,
        "x": 830,
        "y": 120,
        "wires": [
            [
                "565fa3687b2cd82d"
            ]
        ]
    },
    {
        "id": "565fa3687b2cd82d",
        "type": "debug",
        "z": "3e06b3433b7a20ad",
        "name": "",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "false",
        "statusVal": "",
        "statusType": "auto",
        "x": 1090,
        "y": 100,
        "wires": []
    },
    {
        "id": "8970825e3063a997",
        "type": "XLSX-to-json",
        "z": "3e06b3433b7a20ad",
        "name": "xlsx to json",
        "filepath": "msg.filepath",
        "rangecell": "",
        "columnkey": "",
        "sheet": "",
        "x": 570,
        "y": 180,
        "wires": [
            [
                "912504b8ae2aeb06"
            ]
        ]
    }
]

```

---

<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:** [10 June 2022 07:27 UTC](https://discourse.nodered.org/t/using-xlsx-to-json-node-cannot-change-file-after-being-used/63703/2 "2022-06-10T07:27:21Z")

</div>

Normally, when you pass in a configuration option for a node, you should leave that option blank in the node. So try this, blank out the option in the node  
 ![Screen Shot 2022-06-10 at 3.26.53 AM](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/b/4b3e0768ca79990abfee6ba95ddf5e3d2e60226f.png)

---

<div class="post-metadata">

**Author:** ![MAvitia](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/mavitia/32/62984_2.png) [@MAvitia](https://discourse.nodered.org/u/MAvitia)\
**Post date:** [10 June 2022 14:06 UTC](https://discourse.nodered.org/t/using-xlsx-to-json-node-cannot-change-file-after-being-used/63703/3 "2022-06-10T14:06:36Z")

</div>

Thanks for the quick feedback

Actually that is how I was using it, I probably left it there while trying different things.

I completed the project with a CSV to JSON node, but I certainly liked the functionality of the XLSX version,

Do you know how to provide feedback to de developer? To keep improving the nodes

Regards

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [10 June 2022 14:15 UTC](https://discourse.nodered.org/t/using-xlsx-to-json-node-cannot-change-file-after-being-used/63703/4 "2022-06-10T14:15:13Z")

</div>

You can use `npm owner ls {name of node on npm}` to show the email of the node's owner if they don't already provide an Issues page where you can raise suggestions.

---

<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 August 2022 14:15 UTC](https://discourse.nodered.org/t/using-xlsx-to-json-node-cannot-change-file-after-being-used/63703/5 "2022-08-09T14:15:32Z")

</div>

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