we want to save data in one excel document but with multiples sheets, each one will have a specific group of features
please sheet the attached Image
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Hi @boubcher, if you set the fme_feature_type_name attribute to the Sheet Name field in the Excel writer feature type, each feature will be written into a sheet whose name is the same as the attribute value. See also here: Setting Feature Type Fanout
Thanks its now creating sheet for every data group, but I have no idea why it's duplicating the data ,I trayed o play multiple combinations with Feature type Dialogue but with no result
Thanks its now creating sheet for every data group, but I have no idea why it's duplicating the data ,I trayed o play multiple combinations with Feature type Dialogue but with no result
Any idea
save-to-diffrent-sheet2.png
If you check the writer parameters in the Navigator there's one, for Excel, that says "Overwrite existing file", it's set to "No" by default which means each time you run the workspace it appends the results to the file, rather than writing a new copy.
You have removed "TransportationZone**/" (** = 36, 37, 38, 39) from the values of "fme_feature_type_name". If there were "TransportationZone36/BusStation" and "TransportationZone37/BusStation" originally, naturally "BusStation" would get duplicated after translation.