Binary Excel Specific Sheet Read - Is this possible?

[clarrock]

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?

[danilang · Accepted solution]

Hi @clarrock 

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

[Ajin_sl]

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

[Ajin_sl]

@danilang