I have 4 feature types and writing to a single xls file using FME. Each feature type has its own worksheet.
How can I sort the worksheets with FME before creating the xls-file?
I use FME 2012 SP3
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
Have you tried using Sorter?
Each attribute can be sorted alphabetically or numerically and can be sorted either in ascending or descending order. By default, the sort direction is in ascending order. Alphabetic ordering will sort according to ASCII ordering rules.
After sorting, you can write to multiple worksheets in an excel file or perform other types of excel manipulation.
On the writing side, multiple sheets are also supported. In fact, a feature type fan-out will automatically filter your data into a series of sheets by type.