Listing the list of sheet names from XLS

[okka]

Hello,

I'd like to know how to list the sheet names from a XLS file.

I can't convert the file into XLSX, so I'm trying to find a solution to list the sheet names from an XLS file.

I've found the following macro: https://community.alteryx.com/t5/Engine-Works-Blog/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-Al...

But I really don't understand the macro "SheetFinder" itself:

Do I need to change anything in the following Run Command tool?

It looks a bit sophisticated for simply reading a single XLS file... Could you help me out on this?

[KP_DML]

Hi @JokeFun ,

Try running Alteryx as administrator, then run the workflow. Python is attempting to download the xlrd library it needs to run the code, but can't because it does not have access. Running Alteryx as administrator will give the process permission to install the library. Subsequent runs of the workflow on the same machine will not have to run as administrator since the library will already be installed. I prefer to use the non-admin installation of Alteryx to avoid this issue.

[toryrags1]

Nice! Thanks for sharing. Once resolving the xlrd package install it was off to the races! Thanks again.