Question

from 1 excel template to multiple sheets

Forum|Forum|5 years ago
November 9, 2020
1 reply
107 views

+13

alc33
Contributor

Hi!

I would like to duplicate my template (excel) to create multiple sheets based on an attribute on my datas. For example, when my attribute = sheetA, all the datas concerned go to named ranges on the sheetA.

At the end I have one file with multiple sheets.

But I saw this sentence :

https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/xlsx/XLSX_writer.htm

"Named ranges that exist on the template sheet are not duplicated."

So I thought to use feature writer to write each sheet independantly with the same name sheet and then use feature reader + writer to group all the files in one and rename the sheet with the good value.

This solution is a problem for me because I would like to delete the intermediates files automatically but FME can't do that.

I'm not used to write on excel so it became a little complicated for me.

Can you help me?

Thanks!

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.