Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Convert XLS files into XLSX and remove passwords

Ash___123
5 - Atom

Hi,

 

I have a workflow that reads through a folder and opens specific files and tabs using a dynamic input tool.

 

The first issue I have is that you can't import the list of sheet names from .xls files (from what I can see). The second issue is that some of these files are also password protected. Ideally I'd like to remove the passwords automatically instead of entering the passwords individually.

 

If there's a script using python or the run command tool that can achieve this by converting all .xls files into .xlsx and remove passwords on all excel file types (i.e. .xlsx and .xlsm) that would be greatly appreciated. 

 

1 REPLY 1
Labels
Top Solution Authors