Binary Excel Specific Sheet Read - Is this possible?

Hi,

How do i read a specific sheet on an XLSB file? I have multiple XLSB files in a directory/folder and what to read a specific sheet from those files in alteryx (eg Sheet Name = "ABC") and output data from all xlsb files in the folder with sheet name ABC in a union.

Is this possible on Alteryx?

Workflow

Developer

Help

Accepted answers

Since you know the sheet name, you can configure the Input Data tool to use wild cards "*".

This will read the Dates sheet from all the .xlsb files in the directory. Change "Dates" to what is required.

Dan

All comments

Since you know the sheet name, you can configure the Input Data tool to use wild cards "*".

This will read the Dates sheet from all the .xlsb files in the directory. Change "Dates" to what is required.

Dan

It was working fine but suddenly I am getting an error on this.

Quick Links

Tags

This months top contributors

Hollingsworth 335