Skip to main content
Question

Output excel file hiding column names (row 1)


emerson_styles
Contributor
Forum|alt.badge.img+2

I am writing data to an excel file but when I open the written file, the first row of the file (that includes the column headings) is hidden and I have to manually expand it to show the headings. Is there a way to fix this in the writer at all? 

3 replies

jkr_wrk
Influencer
Forum|alt.badge.img+28
  • May 14, 2024

Strange behavior. Do you use a template or do you write to existing file?

If you don't use a template file, maybe using a template file will solve your issue. But i’m curious what causes this behavior.


DanAtSafe
Safer
Forum|alt.badge.img+16
  • Safer
  • May 15, 2024

Hi @emerson_styles Unfortunately this is a known issue, filed as FMEENGINE-82549. The work-around is to set the Row Height to 0 on the Feature Type.

https://support.safe.com/hc/en-us/articles/25407724250509-Known-Issues-in-FME-2024-x


kahlen
Contributor
Forum|alt.badge.img+2
  • Contributor
  • July 5, 2024

I can verify that this issue is also “following” up to FME Flow 2024.0. If you publish a workbench with a excel writer and choose the Data Download service, if you run the script and then download the resulting excel file then the first row has the value 0 in row height and is being hidden.


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