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
- karkan
- mohamad22
- rylanatsafe
- mkludas
- hvukasinovic
- maddiel
- debbiatsafe
- hollyatsafe
- siennaatsafe
- fmelizard
- david_r
- ebygomm
- hkingsbury
- danilo_fme
- caracadrian
- erik_jan
- warrendev
- tcrossman
- vxn43
- thijsknapen
- carmijo
- tomf
- davideagle
- bruceharold
- dbaldacchino1
- nic_ran
- jelle
- kennyo
- chriswilson
- philippeb
- mark_f
- canerakin
- arthur_bazin
- cory
- anamanvil
- milo89
- ciarab
- fme
- juanmahere
- gbj1717
- vki
- revesz
- mpsims
- softwrite1
- bark0s
- gerhard
- kevs-2021
- marko
- ssiegl
- kcoats
- jleoncofgis
- robert.wright
- pwan
- gpoehacker
- tara
- julie.houba
- huotari
- lebowski_mor
- daztreg
- dbaldacchino
- kahlen
- osmanbeg1980
- stefan.vdberg
- dmatranga
- r5
- erooen
- arhayes
- mattias
- mholemans
- mdohm
- geospatiallover
- ericchez
- nixynoodle
- tomhhnk
- chickey
- woody
- iew
- demix
- geoleo
- mark
- cwinfield
- mart
- mvanwie
- susannebell
- hannah.wheldon
- johannafalk
- geoinfomartin
- mbz
- jobrien77
- alexandreroy
- xabi
- markus
- johnwk
- sparker
- eberkel
- ecthelion
- ekkischeffler
- mmccart
- braggken
- roland.martin
- becchr
- timotheebecker
- kieranmg
- richemcd
- anari
- bobw
- fbrws
- hannahwh05
- joshuadamron
- geoal
- jfisch25
- paul_m
- mechomicky_bmcd
- jpvo
- raymondbrunner
- wicki
- johnmarcdechaud
- j.sveinson
- simon_maddern
- amk
- jmiddel
- jurgen
- hrvoje
- tomw202
- phoeffler
- ngoorman
- anoukhenfling
- erikvaldmaa
- patricemarseill
- friedldaniela
- nateneufeld
- perfro
- mapper42
- hendrikh
- ehughes
- jobrien
- zampy
- djacques
- sidrashaheen
- brcalexm
- cillingworth81
- spawkly
- toskent
- cholmes21
- petterlamas
- damianc
This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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 a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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.
+11- Supporter
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
+11- Supporter
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.
+15- Safer
https://docs.safe.com/fme/html/FME-Form-Documentation/FME-ReadersWriters/xlsx/XLSX_writer.htm
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.