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.
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.
It does not seem to work if I want multiple excel files (one for each customer), but within each file two tabs (one based on a French template file and one based on an English template, filled with values of the customer), because it will export to only one tab!
I try to work on it a bit more.
It does not seem to work if I want multiple excel files (one for each customer), but within each file two tabs (one based on a French template file and one based on an English template, filled with values of the customer), because it will export to only one tab!
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.
Does it also works when I have to write different data in the different tabs?
- 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.
