Convert XLS files into XLSX and remove passwords
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Batch Macro
- Macros
- Python
- Run Command
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Ash___123 The below posts might be helpful for your use case
https://creativedata.stream/converting-xls-to-xlsx-files-in-alteryx/
