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!