Solved

Is there a way to generate multiple Excel workbook using only one Writer?

Forum|Forum|6 years ago
September 13, 2019
1 reply
44 views

thomas_

I have to generate approximatively 850 Excel workbook and I was wondering if it was possible using only one Writer or if I had to use 850 Writers.

I thought of the possibility of generating 850 sheets in one Excel workbook, but I would have trouble actually opening the workbook with my computer (lot of memory used).

Also I work with a 2017 version of FME (I stumbled in the past on issue that could be esaily resolved with 2018, but I had to work in the limit of 2017).

Thanks

Best answer by david_r

Have a look at the fanout functionality in FME, it will allow you to split the output over several files depending on a criteria that you can define.

https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_Workbench/Workbench/Setting_Dataset_Fanout_Properties.htm

https://knowledge.safe.com/articles/565/fanout-1.html

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.