Solved

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

  • 13 September 2019
  • 1 reply
  • 6 views

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

icon

Best answer by david_r 13 September 2019, 18:09

View original

1 reply

Userlevel 4

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