I'm trying to solve how I can get the properties for a Excel worksheet. I have over 5000 Excel files trying to parse. These files fall into 6 different formats for data extraction. However all the files are created from an Excel template which starts with all the worksheets for all the different formats. Depending on the user's initial selection using a VBA marco in Excel certain worksheets will be visible or not.
I'd really like to test if certain worksheets are visible and then take actions accordingly in FME.
Also important is all these files are formatted as XLS (older Excel) and not XLSX .
