Skip to main content

Hi All,

I'm experiencing a bug in the Excel writer in the new FME 2024.0. I've made a script that outputs multiple data categories I need to process in a particular order to ensure my calculations are fed as desired. The bug causes the attribute names to not be written in the first row in Excel; it just starts with the data in the second row. Whenever I open the exact same script in FME 2023.2, the writer does write the field row names, without me changing anything in the writer settings.

For now, my solution is to not use FME 2024, but since my customer does use 2024, it's not desirable. Does anyone have any ideas?

Here is a preview of Excel. I can't scroll up to the first row, the data is not hidden, and the navigator also won't allow me to go to row 1.

 

Have you tested the workaround listed in FMEENGINE-82549 : “Set the Row Height to 0 on the Feature Type”?

Potentially related post:

 

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

 


Hi Liam,

 

Thanks for the reply! Very helpfull page which I did not find. Just checked out and it worked. Now I can use 2024 again for my customer. Many thanks!

 

Kind regards, Roelof


I do not understand how the “Set the Row Height to 0 on the Feature Type” can help? The issue is that the row height on first row IS 0, that is why it is not showing. Please explain.  


I do not understand how the “Set the Row Height to 0 on the Feature Type” can help? The issue is that the row height on first row IS 0, that is why it is not showing. Please explain.  

I think it forces the writer to write the first row. For me it fixed the bug


I do not understand how the “Set the Row Height to 0 on the Feature Type” can help? The issue is that the row height on first row IS 0, that is why it is not showing. Please explain.  

I think it forces the writer to write the first row. For me it fixed the bug

But the first row is there already, only that the height is set to 0 (zero). Maybe there are two issues here - one that do not write the first row and the second that the first row is being written but with 0 in height. I have the second issue. Mind you I do not “force it” to write any rows and I do not use any templates either. I use a simple Excel writer.    


Hi!
I had the 1st row hidden using both - the ExcelWriter / FeatureWriter (FME 2024.1.2.0). I set the Row Height to 15 in both writers and it resolved the problem. 


Reply