How to change xlsb file to xlsx using macro or read xlsb file using marco

[SH_94]

Hi Community,

I would like to ask if anyone of you have the read macro to read the multiple xlsb file with the following criteria:

1. Different sheetname

2. Different schema

3. One tab per one excel file

Or is anyone have the marco to change from xlsb to xlsx file?

I have try the other marco uploaded but it failed .

Appreciate if someone can help on this.

[fmvizcaino]

Hi @SH_94 ,

I think you can use the wildcard input from crew macros.

http://www.chaosreignswithin.com/p/macros.html

One thing you need to keep in mind is that you need to also install a specific drive to be able to read xlsxb files and you can find more here.

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

Best,

Fernando Vizcaino

[ArtApa · Accepted solution]

Hi @SH_94 - I have created a workflow, which saves as all XLSBs to XLSCs without worrying what's inside. This is similar as if you'd open all your XLSBs in Excel and "Save as..." them.

In order to run this workflow you need:

1) Connect your Directory tool to the right folder

2) Check location of the "excelcnv.exe" file on your laptop and change it in the formula tool, if needed.

Is that something that you wanted?

[SH_94]

Hi @ArtApa ,

Yup this is something that i looking for.

May i know if you have the workflow that read xlsb file with marco attached? As i would like to look for alternative way to read the xlsb file directly instead of converting to xlsx file first then only read the xlsx file in the alteryx.

Thank you.

[JokeFun]

Hi @ArtApa ,

This command tool is brilliant. However, it could not work in Gallery.

[JokeFun]

@ArtApa Would you please further update the code so that the converted xlsx will be deleted automatically after import finished?

[sarah_salisbury]

Hi @JokeFun, I am also facing this same issue with converting xlsb files to xlsx, and this tool not being able to run in the gallery. How did you resolve this?

[JokeFun]

I have not got a solution on this yet. We are actually converting the format by using excel macros and then let Gallery process the xlsx files.

[ronxav]

Hi Art_Apa,

It's long since you posted this, but hoping to get some assistance with this tool. It saves the xlsx output in the same folder, since this is being pulled from a production folder in my case, can we get this to save the copy xlsx file elsewhere?

Thanks