I’m trying do get a .xls file from a sftp and read the data inside him.
A already got and download the files, but i can’t find how to read. Already try to use binary read with spreadsheet file, but can’t read his content. Somebody know how do it?
mmm, weird it what you did seems like the right approach. Can you please share the workflow with me so that I can have a proper look? just select all the nodes then copy and then you can paste it here.
Files do not get downloaded to the hard drive, they end up in the flow in the binary property you did define. So if you set the parameter “Binary Property” on the “Files-Downloaded” node to “data” and remove the “Read Binary File” node totally it should work fine.