Skip to main content
Solved

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

  • September 13, 2019
  • 1 reply
  • 28 views
T

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

View original
Did this help you find an answer to your question?

1 reply

david_r
Celebrity
  • david_rCelebrity
  • Best Answer
  • September 13, 2019

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

Reply


Helpful Members This Week

Community Stats

31,551
Posts
119,602
Replies
39,190
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.