Skip to main content
Question

Write several sheets in excel file using a template, without removing other sheets

  • June 17, 2025
  • 1 reply
  • 32 views
frc
Participant
Forum|alt.badge.img

Hello, 

I have a workbench with the following elements :

  • 1 Excel writer based on a template file, and with option “Overwrite Existing File” set to Yes (mandatory to use a template).
  • 8 Feature types writing to 8 different sheets of the same Excel file.

As I’ve seen in other posts, this configuration should work.

However, when I run the workbench, only one sheet is filled in the final excel file. If I run the writer Feature Types one by one, they do write their own sheet and remove the others. 

Can someone tell me what is wrong in this configuration ? 

I use FME Desktop 2021.2.

 

 

 

danilo_fme
1 person upvoted this
  • danilo_fme
    danilo_fme

1 reply

debbiatsafe
Safer
Forum|alt.badge.img+20

Hello ​@frc

The behaviour of writing in the individual sheet when the writer feature types are run one by one (via partial run) is expected since only one feature type is run.

If the output sheet name matches the template sheet name in the template file, then the Template Sheet parameter can be left empty on the writer feature types. If they do not match, then the template sheet does need to be specified. 

The writer parameter looks correct if the Excel template sheet name matches the output sheet name.

I have attached an example where features are written to the correct Excel sheet in the template. Does running this workspace create a similar output for you?

 

1 Attachments

Reply


Helpful Members This Week

Community Stats

31,501
Posts
119,408
Replies
39,117
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.