Using fanout to export to excel tabs

Yes, you only need to use one writer and then in the output feature type set the sheet name to something dynamic, i.e. an attribute containing the customer name.

The Fanout for sheets should be in the feature type, not the writer:

When you replace the Sheet1 in the image by the value of the attribute that contains the customer name (use the down arrow to select), it will work as a Fanout and create a tab per customer.

Hope this helps.

I try to work on it a bit more.

If you want to write multiple Excel files you'll need to check the Fanout settings on the writer, that can be done in the Navigator panel. Note you'll still only need one writer.

- Tab A: on position E40 I need to write the name of the organisation (I can do that by changing the start column and row in the feature type)

- Tab B: on position E40 i need to write the name of the organisation in the other language

- Tab C: I need to paste all the information I have on the organisation (just the table that comes out of fme is fine)

They all three have a different layout, so if I insert the template, I only can use one template sheet.

I already checked the fanout option (based on the name) in the writer

split the data in three branches (each for each tabs), made an extra attribute (name of the sheet) so the correct info is placed in the right sheet (based on this attribute), and then merged them back together.

It does not seem to work; nothing is written into the document.