Excel Binary Input into Alteryx

[caltang]

Hi all,

I am aware that it is possible to input Excel Binary into Alteryx, but one must follow these steps:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/How-to-Enable-Microsoft-Exc...

Microsoft Access Database Engine 2010 Redistributable  -> This is required.

Are there any other ways to do so? Especially since some companies may require explanations on why the Microsoft Access Database Engine 2010 Redistributable is required.

Or is that the only way?

Thanks,

Cal

[alexnajm · Accepted solution]

That is the main way, and the only way I am aware of!

[caltang · Accepted solution]

Yeah, just downloaded it after getting approval and Alteryx reads all legacy files just fine. 

For anyone searching, downloading this: https://www.microsoft.com/en-us/download/details.aspx?id=13255

is the only way. 

[flying008]

Hi, @caltang 

If you will, you can use MADE or Python to input binary format of .xlsb file.

[caltang]

Hi @flying008 

Thanks! Do you have a guide?

[flying008]

Hi, @caltang 

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

https://community.alteryx.com/t5/Community-Gallery/XLSB-Reader-and-SheetNameReader-macro/ta-p/951949 

https://community.alteryx.com/t5/Community-Gallery/Convert-xlsb-into-xlsx-and-parse-the-input/ta-p/1... 

[caltang]

Thanks! Though I think it is much easier to download the Microsoft Redistributable package, and is easier in terms of UI/UX for the end users.

[flying008]

Hi, @caltang 

Even you already installed MADE, then you can input one sheet data of xlsb file indirectly,  but you can't import only the list of sheet names.