Typically if writing out the headers of columns to Excel it is necessary to then open the Excel file manually to define a style for the first row (to make it stand out). Often just making the text bold or apply colour to the column name rather than the whole column, for example. The option to do this on the writer would cut out a post process.
Released
Ability to style column headers in Excel writer
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.
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.
+21- Enthusiast
Using a template is a workaround, but this would be neat to add within a workspace.
it would be so much easier than having to use a template especially when you only want to make the headings bold!
my vote added to this too...very surprised it's not an option currently as I would imagine this is a standard requirement for any spreadsheet; it certainly is where I work. Cheers
+14- Enthusiast
Ugh, can't believe this is still not available :( I concur that having an option to style the headers separately from the values would be great. The template workaround is not an option if you want to write to the same file multiple times to insert new data since you have to set the parameter "Overwrite Existing File" to "Yes" to expose the template options.
+4- Contributor
I noticed that there is a setting "Format fields name row" in the Xlsx writer now (I noticed in version 2021.1.2 but it might have arrived earlier). However I cant find any documentation on how to use it unfortunately. But the name of the parameter makes me think that it might be related to this idea.
+18- Safer
https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/xlsx/XLSX_writer.htm