Hi,
One of the input file I am receiving is .XLSB (binary format). I am not able to read it thru input file tool.
What is the best way to covert/read .xlsb file in Alteryx ?
thanks in advance
aK
Hi @Alteryx_user_aK
I tried here, unfortunately got the same error with the Read_All_Excel_Files macro. Maybe it need to be updated for some reason, it used to work fine.
So, i suggest you to try the first option (convert xlsb to xlsx). This macro is mine, so i can help you more if you have any issue using it: ttps://community.alteryx.com/t5/Community-Gallery/Convert-xlsb-into-xlsx-and-parse-the-input/ta-p/1...
You should be able to read the file in using the Output Data Tool as an xls file type.
You may need to install the Microsoft Access Driver, available here: https://www.microsoft.com/en-US/download/details.aspx?id=13255
I just installed the 32 bit version and it worked for me,
Another options,
1-You can convert .xlsb to. xlsx - and import the xlsx data to the same workflow - using this macro: https://community.alteryx.com/t5/Community-Gallery/Convert-xlsb-into-xlsx-and-parse-the-input/ta-p/1009750
2-You can try to read them directly with this macro: https://community.alteryx.com/t5/Community-Gallery/Read-All-Excel-Files/ta-p/897750
Hello Felipe,
Appreciated your reply. I have downloaded the macro to read the .xlsb file but getting below error. Tried to fix it but somehow did not work.
going with option#2.
Excel File Opener (5) Tool #3: Record #1: Tool #26: The external program "..\SupportingFiles\unzip.exe" returned an error code: 9Tool #30: The field "Sheet Names" is missing. Compare the tool configuration with the input stream.
Any points on fixing these issues.
Thanks
