listing list of sheet names of xlsb file

[Shaaz]

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 ?

[pedrodrfaria]

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]

Hey @pedrodrfaria

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

[sarah_salisbury]

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

[rohitaakulaexl]

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