2

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

1
  • I use a Oracle Database
    – Dominik
    Commented Dec 17, 2015 at 10:40

1 Answer 1

2

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.

1
  • I found a way by myself. Before I write the xls-file I sort the Data with the AttributeFilter. So I can sort by the attribute I want. Thanks for the quick answer MaryBeth! The Question can be closed
    – Dominik
    Commented Dec 17, 2015 at 10:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.