Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

listing list of sheet names of xlsb file

Shaaz
9 - Comet

we dont have an option to select list of sheet names for xlsb file.

 

Can you please provide me an approach where we can list down all the sheet names present in xlsb file ?

4 REPLIES 4
pedrodrfaria
13 - Pulsar

Hi @Shaaz 

 

I do not believe it supports this feature for xlsb files.

 

However, you can always convert them to xlsx and use it.

 

I attached a WF that will use the Run Command to update the file extension from XLSB to XLSX. All the data will be the same, it is just updating the file extension. This should help you.

 

 

Jordan_Collins
5 - Atom

Hey @pedrodrfaria

 

I downloaded the WF and did not have success changing the file type. Any thoughts?

sarah_salisbury
6 - Meteoroid

Hi, I am facing the same issue. Is there a resolution for this? Thanks!

 

rohitaakulaexl
5 - Atom

I tried to debug provided workflow, you can update formula to Trim(Substring([FullPath],0,length([FullPath])-4),".") this worked for me.

Labels
Top Solution Authors