Skip to main content
Solved

Create Multiple Sheets in a single Excel Spreadsheet - Fanout question

  • May 24, 2025
  • 1 reply
  • 53 views
vxn43
Supporter
Forum|alt.badge.img+18

Hello, 

I am having difficulties creating a spreadsheet with 2 sheets. In the screenshots included I have 2 Excel Writers. I have chosen Fanout Dataset since I want the file name to include a timestamp. The workspace runs successfully. But only a single sheet in the spreadsheet is written. 

Daily Totals is included as a sheet in the spreadsheet, and Running Total is not. What do I need to do in order to include both sheets: Daily Totals and Running Total (seen as two Writers in the screenshots below).

 

When I do not choose Fanout Dataset, the two sheets are written to the spreadsheet, but the file name has no timestamp. When I use Fanout Dataset one sheet is written to the spreadsheet and the file name has the timestamp. 

 

My workspace includes the DateTimeStamper Transformer that creates the _timestamp attribute.

.

 

 

 

 

Best answer by vxn43

I solved the problem. My DateTimeStamper Transformer was not included in the part of the workbench that writes to the 2nd sheet in the spreadsheet. This transformer was only included in the part of the workbench that writes to the 1st spreadsheet. 

I moved the DateTimeStamper Transformer to be immediately after the Reader to ensure both Writers receive the DateTimeStamp. 

    danilo_fme
    raghavendrans
    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.

    1 reply

    vxn43
    Supporter
    Forum|alt.badge.img+18
    • vxn43Supporter
    • Author
    • Supporter
    • Best Answer
    • May 24, 2025

    I solved the problem. My DateTimeStamper Transformer was not included in the part of the workbench that writes to the 2nd sheet in the spreadsheet. This transformer was only included in the part of the workbench that writes to the 1st spreadsheet. 

    I moved the DateTimeStamper Transformer to be immediately after the Reader to ensure both Writers receive the DateTimeStamp. 

    hkingsbury
    vxn43

    Community Stats

    32,129
    Posts
    121,967
    Replies
    39,779
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    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.