Hello,
I'm new in FME but have some basic knowledge. I am trying to fetch some data from excel file and use it for analysis and making graphical representations (charts) but I am stuck with the steps much prior to this analysis. Unfortunately, excel file is not very well organized nor structured so I'm trying to overcome this problems and I managed to read some amount of data in structured form.
What I'm having problem with is this: excel is organized in many sheet: first (main) sheet has summary data from all the rest of sheets and one column is hyperlink to a specific sheet which holds the data in more detail. I would like that after the running of the workbench I have the ability to choose the specific sheet for analysis based on list of sheets I have already obtained from hyperlinks in the main sheet.
I tried to figure this out for the whole day without success. I would appreciate any suggestions or pointers.
Thank you in advance!
