Input Binary excel file(.xlsb)

[Anasalter]

Trying to input binary excel file(.xlsb) but getting error 
' You have found a bug. the pipe has been ended'.

[OTrieger]

@Anasalter 

Alteryx is not supporting this format, convert it to xlsx

[Raj]

@Anasalter 
Refer this
this should solve the issue

Excel Holiday Macro that was built by an Cameron Steele at Alteryx.  IT's a really awesome macro that makes bringing in Excel files a lot easier.  check out the blog post - https://community.alteryx.com/t5/Engine-Works-Blog/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-AL...

if you scroll to the bottom of it, you will see a link to it in the Gallery.

Mark done if solved.

[Raj · Accepted solution]

@Anasalter 

The input .xlsb method of python can use macro in gallery. please find it out as your need.

XLSB Reader and SheetNameReader macro - Alteryx Community

Convert .xlsb into .xlsx and parse the input - Alteryx Community

[Anasalter]

@Raj Thank You, it worked.