XLS - still cant see data unless file is open

Hi,

Trying to solve this issue still where I have excel files in an *.xls format.

Using the workaround and appending the file path to:

C:\temp\Book1.xls|||'<SheetName>$'

lets me select the sheet name to open.

However it wont load all the data in - only the first row - unless the file itself is open.

I have had the Microsoft Access Database Engine 2010 installed, and can now read the file directly using either xls or xlsx (legacy) - however it still wont load any data unless the file is open.

I have searched a lot on here with no luck currently.

Can someone please help in how to solve this issue? I dont want to have to open every file when running workflows on a large scale.

Thanks

Input

Accepted answers

flying008

Hi, @Baz123

If that's the case, you could try script to save these xls files as xlsx files before importing , and that might solve your current problem.

All comments

flying008

Hi, @Baz123

1- Add Browse tool after your input tool with running, see the output again.

2- Upload your xls file to here, maybe we can repeat the problem.

Baz123

Hi @flying008,

The files come from Oracle Discoverer (old tool I know).

If I export the data from Discoverer it saves it in a local folder. If I try to bring in this file straight from the network location then it only brings in the first row.

If I open the file in question, and just save it as is, then attempt to bring it into Alteryx then it works fine???

I cant tell if something is happening to the file by simply opening it then saving and closing??

FWIW all other xls files work now. Its just these ones I try to workflow from the default directory that Discoverer saves to (C:\user\...) I have permissions on the directory as I can open and save from it.

Thanks

flying008

Hi, @Baz123

If that's the case, you could try script to save these xls files as xlsx files before importing , and that might solve your current problem.

Baz123

Hi @flying008,

It appears the issue is when trying to open a file that discoverer has autosaved in the local network directory. If I export the data from discoverer, and hit save before closing (not simply just closing the file) then Alteryx has no problems when opening it.

Not ideal, but its a workaround until I can hook it up to the data source directly.

Thanks

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703