Skip to main content
Solved

Excel writer bug in FME2024

roelofvos
Contributor
Forum|alt.badge.img+5

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.

 

Best answer by liamfez

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

 

View original
danilo_fme
1 person upvoted this
  • danilo_fme
    danilo_fme
Did this help you find an answer to your question?

6 replies

liamfez
Influencer
Forum|alt.badge.img+34
  • liamfezInfluencer
  • Influencer
  • Best Answer
  • June 11, 2024

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

 

not a bot
geomancer
danilo_fme
DanAtSafe
4 people upvoted this
  • geomancer
    geomancer
  • danilo_fme
    danilo_fme
  • DanAtSafe
    DanAtSafe
  • roelofvos
    roelofvos
roelofvos
Contributor
Forum|alt.badge.img+5
  • roelofvosContributor
  • Author
  • Contributor
  • June 12, 2024

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

danilo_fme
liamfez
2 people upvoted this
  • danilo_fme
    danilo_fme
  • liamfez
    liamfez
kahlen
Contributor
Forum|alt.badge.img+2
  • kahlenContributor
  • Contributor
  • July 5, 2024

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.  

danilo_fme
1 person upvoted this
  • danilo_fme
    danilo_fme
roelofvos
Contributor
Forum|alt.badge.img+5
  • roelofvosContributor
  • Author
  • Contributor
  • July 5, 2024
kahlen wrote:

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

danilo_fme
1 person upvoted this
  • danilo_fme
    danilo_fme
kahlen
Contributor
Forum|alt.badge.img+2
  • kahlenContributor
  • Contributor
  • July 7, 2024
roelofvos wrote:
kahlen wrote:

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.    

danilo_fme
kirken
2 people upvoted this
  • danilo_fme
    danilo_fme
  • kirken
    kirken
kirken
Contributor
Forum|alt.badge.img+6
  • kirkenContributor
  • Contributor
  • November 4, 2024

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. 

danilo_fme
kahlen
2 people upvoted this
  • danilo_fme
    danilo_fme
  • kahlen
    kahlen

Reply


Most helpful members this week

Community Stats

30,839
Posts
116,903
Replies
38,660
Members
Terms & ConditionsCookie settings

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
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.