I have a report coming out of an out-of-the-box Vertigis Studio workflow that is written out as multiple excel files. Each has the title Results (number) e.g. Results (1), Results (2). (The dataset name is exposed as the tab name, for some reason and not the file name). If I were reading a group of spreadsheets with the same structure, I would just set the reader to read *.xlsxw, and it would be non problem. However - here I have differing attribute schemas.
The datasets called by each report vary depending on a spatial interaction, but come from a finite list of possibilities. And as I say, the attribute schemas can vary.
I need to read all files of the output, expose attributes and write out into a single excel sheet, fanned out by dataset (presumably using the FME basename - is it possible to grab the tab title instead?)
I have done the reading thus far using a Reader set as pic attached ...however, this isn't dynamic. Moreover, this workspace needs to be usable by a relative FME novice.
Then I need to write out to separate excel tabs. I have a writer set to fanout by fme basename. Although the translation succeeds, there is no output file.
Would welcome any hints as to how to proceed a) to make the reading able to cope with changing number of files and b) to get writing to work.