Skip to main content
Solved

Customize Excel Spreadsheet before or at Writer

  • January 29, 2026
  • 2 replies
  • 34 views

vxn43
Supporter
Forum|alt.badge.img+18

Hello, 

I have an Excel Spreadsheet that I need outputted in a specific format. I am only working with 175 records, so I could complete the customizations using Excel in a couple hours. But, I wanted to run this by the FME Community first. 

Here is a screenshot of the spreadsheet output format I need:

  1. Column names must be bold.
  2. Col A cells need to colored yellow.
  3. Col A cell values need to bold and red.
  4. Whenever there is an X in Col A then the entire row needs to be bold red
  5. The APN column needs to counted with the total shown in the row of the above screenshot.

At this point I am not looking for specific instructions on how to set up a spreadsheet like this. If you can provide any that would be helpful. I know I would use the Excel Styler Transformer. Maybe the Aggregator Transformer to sum the APN column, But can someone provide me at least a general idea on how to set up a spreadsheet like this using FME? is it possible? What parameters would I use/set up using the Excel Styler? Given I can do this manually in about 2 hours, is it even worth the time trying to figure this out using FME? Any advice is welcome. 

Best answer by hkingsbury

You can also use a template Excel file:

 

https://support.safe.com/hc/en-us/articles/25407596375309-Using-a-Template-File-when-Writing-Excel-Data

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.

2 replies

philippeb
Enthusiast
Forum|alt.badge.img+22
  • Enthusiast
  • January 29, 2026

Yes, it is possible to set everything up.

It worth it if it’s something you’ll need to do more than once.

ExcelStyler indeed, but all the titles settings are configurable into the Excel Writer.

 


hkingsbury
Celebrity
Forum|alt.badge.img+68
  • Celebrity
  • Best Answer
  • February 1, 2026