Skip to main content
Released

ExcelStyler - Modify Attributes Font

Related products:Transformers
  • August 17, 2018
  • 7 replies
  • 53 views

philippeb
Enthusiast
Forum|alt.badge.img+22

I don't think it is possible to do that in FME right now, but it would be cool to be able to modify the attributes font when writing a XLS file. I like my attributes to be in BOLD when I create and share a XLS. Thanks Safe!

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.

7 replies

david_r
Celebrity
  • August 17, 2018

Have you looked at the ExcelStyler in FME 2018? You can set separate font and color styles per cell or per row. For example:

'

Or do you need something else that isn't currently supported?


philippeb
Enthusiast
Forum|alt.badge.img+22
  • Author
  • Enthusiast
  • August 17, 2018
In your example, I would like to generate automatically Column1 and Column 2 in BOLD.

 

The attribute's name, the line 1.

 

 


david_r
Celebrity
  • August 17, 2018
Aha, thanks, that makes sense.

 

 


ebygomm
Evangelist
Forum|alt.badge.img+51
  • Evangelist
  • August 17, 2018

You can use a template sheet with the first row blank but formatted in bold if you are writing attribute names into the first row.


philippeb
Enthusiast
Forum|alt.badge.img+22
  • Author
  • Enthusiast
  • August 20, 2018
Yeah I'm doing it with XLS files that need to be generated every X times. But for a one shot creation, it's useless.

 

 


ebygomm
Evangelist
Forum|alt.badge.img+51
  • Evangelist
  • August 20, 2018
I don't quite follow, you can use the same template for every situation

 

 


philippeb
Enthusiast
Forum|alt.badge.img+22
  • Author
  • Enthusiast
  • November 9, 2018