Input data - excel .xlsb

HaS

Hi all,

I would like to use the option to import an excel file with the extension .xlsb

The option of "Import only the list of sheet names" however this option seems not available when using an excel binary file. 

This option is available when importing an .xlsx file.

Can you please advise how to use the option Import only the list of sheet names in combination with an .xlsb file?

Thanks

Best

atcodedog05

Hi @HaS 

Alteryx doesn't have the option to provide sheetname for .xlsb file. It has been submitted as an idea. You would need to use R or Python to get sheetname.

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/XLSB-Sheetnames/idi-p/620666

Hope this helps : )