Automatic File Names

to change the sheet name you will need to set it in the Feature Type parameters of the output feature type. Here’s a screen shot below. The Fanout will create multiple files, this method will create multiple sheets. 

In my experience the FeatureWriter is a more intuitive way to configure fanouts than classic Writers. When we train a new teammember in FME, the first thing they learn is to let the classic Readers and Writers be and use FeatureReaders and FeatureWriters instead.

to change the sheet name you will need to set it in the Feature Type parameters of the output feature type. Here’s a screen shot below. The Fanout will create multiple files, this method will create multiple sheets. 

 

 

Thank you for the quick response. I’m sorry, I see now that my question was not very clear. I am trying to create a variable file path that the excel book is saved to based off of some predetermined data.

For example; I have a sheet that assigns job IDs to groups, then there is a filter that I have to manually choose the group to process and also assign the file path which is always based off of the group chosen and the date. The next part of the project is to loop through all of the groups but baby steps first.

The FeatureReader is more intuitive:

to change the sheet name you will need to set it in the Feature Type parameters of the output feature type. Here’s a screen shot below. The Fanout will create multiple files, this method will create multiple sheets. 

 

 

Thank you for the quick response. I’m sorry, I see now that my question was not very clear. I am trying to create a variable file path that the excel book is saved to based off of some predetermined data.

For example; I have a sheet that assigns job IDs to groups, then there is a filter that I have to manually choose the group to process and also assign the file path which is always based off of the group chosen and the date. The next part of the project is to loop through all of the groups but baby steps first.

@sbertrand Are you saying that you want ONE xlsx file with ONE sheet written out to different folders based on the data that is contained within the xlsx file and sheet? So if the data has values of A, B, and C. You would get 3 folders (A folder, B folder, and C folder) each with one xlsx file and one sheet that contain just the A, B or C data respectively.