Sort Excel table sheets with FME

Question

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

Answer 1

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.