I'm sure someone has ran into this issue before, but I can't seem to find any intuitive way of accomplishing this.
I am trying to setup an excel spreadsheet reader with the constraint that my header (column name) data is contained on row 3 and my actual data begins at row 4. Row's 1&2 contain groupings of the column names (in row 3) and can be disregarded all together.
How can this be done in an FME workbench? Is it possible out-of-the-box? or is custom coding/scripting required?
Thanks in advance.
Regards,
JP