read xlsb files with office 365

Before migrating to office 365, I was using the macros from Read-ALL-Excel-Macro to import xlsb files.

Today I realized this macro was not supporting xlsb anymore under office 365. The message is-

Error: SheetReader (83): Record #1: Tool #1: Error opening connect string: Can't create Data Source Object.

Besides installing the access driver, is there any other method? PS. Not sure if the new version of of Read All Excel Macro works with 365, I cannot download the latest version due to company security settings.

Input

Batch Macro

Accepted answers

Felipe_Ribeir0

Hi @JokeFun

Yes, it works on Gallery. If the gallery has all the necessary python libraries installed.

To change the kernel, go inside the macro, click on the python component, Kernel, Change Kernel and select the Kernel name that is available for you.

After that, click on restart kernel and save the workflow.

All comments

Pawel_Paleczny

Hello JokeFun,

It seems that in the Gallery there is no supported macro for reading xlsb files from O365 however maybe you can use OneDrive tools where you can xlsx files (link to this tool below).

https://community.alteryx.com/t5/Public-Community-Gallery/OneDrive-Tools/ta-p/877893

Felipe_Ribeir0

Hi @JokeFun

I cannot test with O365 now, but this macro is able to convert .xlsb into .xlsx and input the data. Maybe it work for you.

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

If the provided answer helped you to solve the problem/was correct, please accept it as a solution

Thanks.

JokeFun

Hi @Felipe_Ribeir0 , Thanks a lot.

I have the 2020.3.5 version of designer. Not sure if it supports the Python tool. But it is saying: Error: Python (3): Failed to find virtual env named: "designerbasetools_venv"

And even apart from that, do you know if this macro works in Gallery?

Felipe_Ribeir0

Hi @JokeFun

Yes, it works on Gallery. If the gallery has all the necessary python libraries installed.

To change the kernel, go inside the macro, click on the python component, Kernel, Change Kernel and select the Kernel name that is available for you.

After that, click on restart kernel and save the workflow.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703