Skip to main content
Solved

Customize Excel Spreadsheet before or at Writer

  • January 29, 2026
  • 2 replies
  • 33 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

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