why cannot enable the option import only list of sheet names in input data tool

[Sarreddy]

Hi Team,

in input tool why I didn't enable the option import only list of sheet names' PFA screenshot.
Could you please some one help me on this.

thanks,

Ajith Reddy

[ShankerV]

Hi @Sarreddy 

As far I could see in the partial screenshot, you have linked to the directory tool to input all the excel sheets.

It will input the list of file names, then you have only the sheet names.

Can you please show where exactly the error pop up.

Many thanks

Shanker V

[OllieClarke]

Hi @Sarreddy 

That option is only available for .xlsx files, and you are importing an .xls file

If you really need to, there is a python method in this thread here

But if you can convert your file to an .xlsx then that would be much easier :)

Ollie

[DavidSkaife]

Hi @Sarreddy 

It's because you're trying to import a 97-2003 file which uses legacy drivers.

You have two choices; manually save the file as xlsx or use Alteryx to do that for you. More info here - https://community.alteryx.com/t5/Alteryx-Designer-Discussions/workflow-Converting-xls-file-to-xlsx/t...