Solved

Excel writer bug in FME2024

  • 11 June 2024
  • 5 replies
  • 86 views

Badge +2

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.

 

icon

Best answer by liamfez 11 June 2024, 17:13

View original

5 replies

Userlevel 5
Badge +24

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

 

Badge +2

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

Badge +2

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.  

Badge +2

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

Badge +2

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.    

Reply