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.

Common Use Cases

Accepted answers

ArtApa

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?

XLSB2XLSX_AA.yxmd

All comments

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-Binary-Excel-Legacy-Access-accdb/ta-p/513178

Best,

Fernando Vizcaino

ArtApa

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?

XLSB2XLSX_AA.yxmd

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?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703