community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More

Error opening an XLS (not xlsx) file

Atom

I have the same issue - is it possible to tackle it without rolling back the Windows update?

I do not think so. I tried to fix the connection drivers with Excel, I made some changes but it did not work. It only worked when I removed the Windows update.

Meteor

Hi -

 

Thanks @stef_bolo. I uninstalled Windows Update  kb4041676, restarted my computer and boom - all my .xls linked workflows started running again and I was able to input .xls files! A miracle! Day saved!

 

However, I believe this may only be a temporary fix as a new update may come along and we are back to square one. Also I am not sure what it means for our computers now that we have uninstalled this update so we can continue our Alteryx work - are we more vulnerable than before 12 Oct 2017 (that's a MS question, though)?

 

I echo various others on this forum - please can Alteryx look into this issue caused by the MS update and help coming up with a long term fix. We all know that MS should be playing nice with other software - but that's never the case is it?!

 

Thanks,

 

Yusuf

 

 

Alteryx
Alteryx

Hello,

 

This issue has been reported, replicated, and escalated to our engineering and Product Management teams. Please open a Support ticket to report the issue if you encounter it so we have clear documentation of the impact of this issue and contact information in order to communicate a solution or fix. Thank you!

Cailin Swingle
Sr. Manager, Customer Support

 

Couple of quick finds that may help others:

- use formula & run command tools to convert applicable files to csv first: https://stackoverflow.com/questions/1858195/convert-xls-to-csv-on-command-line

- use batch files as "before run" workflow events to run excel macros that will convert applicable files to .xslx: https://superuser.com/questions/524119/batch-convert-xls-to-xlsx

 

I have not checked the gallery but it seems both of these activities might be well suited for macro-packaging, if made to be dynamic enough. 

Alteryx
Alteryx

@jbailey5280@ClaudiaV@YK@renanpinheiro@ekindmr

 

Thank you all for your contributions to this topic and for discussion around potential solutions. Please see this Knowledge Base article for official workarounds available at this time. We (Alteryx Customer Support and Alteryx Engineering) are working diligently to understand the most effective way to address this issue and experience. The proposed solutions are quite manual, but at this time are the only official workarounds. Please contact Customer Support if you need to further investigate your options to resolve this issue while we wait for a fix. Again, thank you for your contributions and for logging a ticket so that we can ensure you remain in the loop on any updates.

Cailin Swingle
Sr. Manager, Customer Support

Nice, that fix of just selecting another file format isn't bad at all. To avoid the file browse issue on new connections, I suspect you could also try adding an input tool then just pasting in the full file path, then changing the format/driver, then updating the sample. Not terribly tedious.

Alteryx
Alteryx

@jbailey5280 you are absolutely right about pasting the full path, then updating the driver/file format!

Cailin Swingle | Manager, Customer Support

Cailin Swingle
Sr. Manager, Customer Support
Meteoroid

Howdy Community,

Long time :)

jBailey great call on that vbscript. I took it and macroized it, and then made an app so you can point at a directory and it'll convert all the xls files in it to csv.

 

It took some doing to get this to export (it's architected w/ ~7 custom macros), and it's late, so this may not work on your first try, but with some community trial/testing i'm sure we'll have a good tool here.

 

nitey

Dan JonesXLSConverter1.png

 

 

 

Alteryx
Alteryx

Nice team work! It should be noted that a .csv will read in all fields as Strings and if the exisitng workflow is utilizing non-string fields, a .csv will break the workflow unless field types are accounted for in a newly added tool, like a Select. In the KB you can read how.xlsx files will fix the error issue and would likely be more congruent in terms of field types.

Cailin Swingle
Sr. Manager, Customer Support
Labels