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.
@Ash___123 The below posts might be helpful for your use case
https://creativedata.stream/converting-xls-to-xlsx-files-in-alteryx/
User | Count |
---|---|
18 | |
14 | |
10 | |
6 | |
6 |