Skip to main content
Question

Dynamic Excel Writer loses font settings


davtorgh
Contributor
Forum|alt.badge.img+10

Hi,

when writing using a dynamic Excel Writer (in my case there are no columns defined at design time - see attached screenshot), the font settings get lost in the output file and also in the Feature Type Writer itselfs when I double-check it.

Has anyone solved this issue?

Thanks!

 

5 replies

liamfez
Influencer
Forum|alt.badge.img+33
  • Influencer
  • January 22, 2025

Are you using an ExcelStyler for styling the columns, or just the formatting settings in the writer?


davtorgh
Contributor
Forum|alt.badge.img+10
  • Author
  • Contributor
  • January 23, 2025

Both ways, same negative result.


saraatsafe
Safer
Forum|alt.badge.img+8
  • Safer
  • January 29, 2025

Hi ​@davtorgh, I did a quick test and was able to apply styling on an Excel sheet. If you’re using the ExcelStyler, please take a look at the Feature Information Window of one of your features. Is there anything in the xlsx_row_formatting field? 
What version of FME are you using? I was able to make it work in FME 2024.2. 

 


davtorgh
Contributor
Forum|alt.badge.img+10
  • Author
  • Contributor
  • January 30, 2025

Hi ​@saraatsafe,

I’v tried a bunch of times with the ExcelStyler (inserting one, removing it and inserting another one and so on) and, in the end, it worked, but it seems to happen randomly. I’m using FME 2023.2.4.0 (20240416 - Build 23785 - WIN64).

By the way, the font settings aren’t applied to the header row (the first one), but only to the data rows (the following ones).

 


liamfez
Influencer
Forum|alt.badge.img+33
  • Influencer
  • February 3, 2025

Sorry for the late response.

Yes by default the font settings from the ExcelStyler will only be on the data when you are outputting the Field Names to excel as heading. I typically apply the heading style that I want in the writer and then style the rest of the data with the ExcelStyler (the styling from the ExcelStyler will take priority for the data).

If you want to style everything in the ExcelStyler, you would want to create a single feature to contain all of the information that you want to end up being the header and then not output field names when you go to write it.

Is there any style information involved in the schema that you are using?


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings