Error Inputting .xls files

[mystasz]

Hi Community,

I'm having some trouble reading .xls files. I have about 4 files with the similar naming conventions like attached (1_XLSDocument, 2_XLSDocument..and so on)

I put the input tool on my workflow > changed the file format to Microsoft Excel 1997-2003 (*.xls) > checked "first row contains data" > connected my first file. I get the below error. Ideally, I'd like for the first document to connect successfully, then change the connection to pull the rest of the 3 files in the directly (*_XLSDocument)

My Alteryx specs:

Alteryx Admin Designer

Version: 2021.3.3.63061

Running Non-Elevated

[mystasz]

I'm not sure why but I'm actually able to input both. The sample files were created off of my original files and then zipped. They input correctly, but the original files that were not zipped do not. Although they are both .xls files. Not sure if zipping has something to do with this nonsense. 

Edit: It was actually me saving it as a recognizable file type before providing you with the sample set. I guess this takes us back to the original question, how would I input this type of document without having to manually change it..

[Felipe_Ribeir0]

Hi @mystasz . I know that this post is old, but i had the same problem and now i have a solution for it. The idea is, python component is converting .xls into .xlsx and using the .xlsx as input.

Convert .xls into .xlsx and parse the input - Alteryx Community

Hope that this is useful for you!