Flow doesnt read data from xlsx

Hello everyone. I have created a flow that watches for excel files in a folder, then writes the data from the excel file to an MSSQL database.
For a strange reason, my flow does not read the data from the excel file. It appears to be "empty".
This is the flow-

When I attach a debug node to the "sheet" node I receive a msg.payload undefined response.
When I attach the debugger to the "sheet to json" node I receive a msg.payload empty response.

What am I missing? I use the same flow construction on other flows and they work great.
I highly appreciate any help.

Just tested it with other excel formats that I use and it works. That means something off in my file. Cant seem to lay my finger on it. Any advice?

Can you show us how you have configured the Watch node?

Also connect a debug node to the watch node, set it to Output Complete Message and show us what it sees.

Edit: Also see what is coming out of the File node.

This is the watch node-
It actually does manage to identify the file, the issue is that it says that msg.payload is empty eventhough there is data in it.


This is the full message debug from the watch node.


Also attached a full msg debug to the "sheet to json" node-

msg debug from File node-

Did you see the comment at the bottom of the watch node image that you posted?


Though I am surprised it worked at all without them.

Why is the filename different in the message from the Watch node and the output from the File node?

Are you getting multiple messages from the Watch node? That can happen because it tells you about the generation of temporary files, and in addition it can tell you before the file write is fully complete, so you may get multiple messages for the same file.

Thats because the other part of my flow adds a timestamp to the filename and then moves it to another folder.
For the sake of the screenshot I copied and pasted the file from the other folder back to the watched folder.

Did you see my second post?

I don't understand in that case. The File node is connected directly to the Watch node.

Yes I am getting multiple messages from the watch node.

What happened is that I copied a used file from the "archive" folder. The file had the original file name + timestamp.
I then pasted it to the watched folder. That explains why the name is different in the File node output.

After approximatly 4 hours of trying to figure out whats wrong, I came to the realization that theres nothing wrong in the flow. The problem is in the specific Excel file I had been working with.
After copying the format to a new excel file, it worked.

Much thanks Colin for all the help and advice!

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