Hello everyone, I have a flow where I need to import the list of sheet names for XLSB files. Changing the file format is not an option, so I am wondering if there is any way to import the list of sheet names for this file type?
@Hreimer22 Why saving the files to xlsx is not an option? You can do it with Alteryx, use a Run Command save copy of the files to a different folder as xlsx get the list of sheet names and delete them with a Run Command. You will not need to open manually even one file.
If this is an option, I would need to change to .xlsm because there are macros in the file. I am not super technical, what would the command look like?
@Hreimer22 You do not need to worry currently about the original files, the idea is to get the needed data without impacting the original files. What will you need to do with the list of sheet names? Why do you need them?
The XLSB format is a binary format, not too dissimilar to the old xls format. The post-2007 xlsx are of an OOXML format whereby you can look into the underlying xml and get the sheet names.
