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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance between 9am-11am MT on Saturday, January 25th, which may impact your experience. Thanks for your patience as we work on improving the community!
SOLVED

Is there any way to read from a Protected .xls file?

Meteor

hi Alteryx Community,

 

I've had a good look around, but haven't been able to find an answer to this...

 

One of the files we get from a Client Portal comes down as a Protected .xls file. When we try to connect in Alteryx we get the following

 

Protected xls.PNG

 

Firstly we can only see the range 'Print Titles' and not the 'Worksheet name'...and even with this if we try to execute it gives the above error.

 

Has anyone else had any experience of this...and if so did you find a solution.

 

If you need anymore information, please let me know

 

Many Thanks

Simon

i never seen this error before

could you please uplaod the sample xl file ?

Highlighted
Meteor

Many thanks for getting back to me so quickly...and in the attempt to create an 'anonymised' version to post I think I've found the problem!!

 

So by 'Protected View'...it is opening in Excel with the following warning

 

Protected Excel.PNG

 

initially I thought (wrongly!) this has been the way the file had been set up...however what is actaully the problem is that the file is originally created/saved in 'Excel 3' (I'm no spring-chicken...and I don't remeber this version, so the portal we get the file from must be super-ancient!!). It is actaully Excel that is opening the file in a 'Protected' environment. We can change these in the following setting in Excel Option -> Trust Centre -> Trust Centre Settings

 

Excel 3 Files Blocked.png

 

This also means I was unable to re-produce an 'anonymised' version of my file, as Excel won't let me save any earler than Excel 2005 (and rightly so!)

 

I suspect that the error Alteryx is generating is that the current JET driver can't read such on old file type (usually the issue is not having the latest driver...this one is that the driver isn't old enough!!). However we're not (even if we could find such an old driver) roll it back just for this file. We'll probably try to speak with the Portal owner, or re-save the files as part of the process prior to bringing into Alteryx

 

I'll leave this post up in case anyone else has a similar error.

 

Thanks again

 

Sometimes it just a help to talk/think through the problem!!

Labels