***Note from Migration:***
Original Title was: Excel Reader - select Worksheets to read by order in XLS/XLSX file rather than Worksheet name
I would like to be able to choose the Worksheet to read from an XLS/XLSX file by the order it appears in the file, rather than have to specify the name. I have recently had to batch process a large number of Excel files where the Worksheet names were not known. There didn't seem to be a satisfactory way of dealing with this (I searched the Knowledge Center) so I end up creating 2 Workspaces and using the SchemaReader, WorkspaceRunner and FeatureReader to do what I needed. Even then, the process crashes randomly if I try to process more than 2 pairs of Excel files at a time (FME 2016.1, need to try in FME 2017).
It would have been a lot easier if I could have specified the Worksheet number in the Excel Reader, as I was always only reading the first Worksheet and the name wasn't important. OK, so I only had one Worksheet in each Excel file, but for multiple sheets you could specify which numbers you wanted e.g. read sheets 1,3,4,6 (or zero based if you prefer). Worksheet name could be exposed as a Format Attribute.
