Skip to main content
  • EN

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? 

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.

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

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


Community Stats

30,159
Posts
114,480
Replies
37,806
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.