Skip to main content
Question

Dynamic writer excel: date is converted to number when using excelstyler

  • March 25, 2026
  • 2 replies
  • 21 views
arnovananrooij
Contributor
Forum|alt.badge.img+5

Hi,

I have a strange issue when writing to excel. I have a feature writer to excel in dynamic mode. To prevent numbers being converted to a scientific notation I added a Excel Styler where I set the custom numer format to 0. This works perfect.

The problem is that now my dates and datetimes are suddenly shown as number. When I change the cell format to date it shows the date, but I want it to directly show the date. When I remove the ExcelStyler, dates are shown as dates. Anyone any idea how to fix this?

I use FME 2023.2.5.

    2 replies

    hkingsbury
    Celebrity
    Forum|alt.badge.img+70
    • hkingsburyCelebrity
    • Celebrity
    • March 25, 2026

    You should be able to set precisely which fields (attributes) the style applies to. By default, I believe it will apply the defined style to the whole row (feature) 

    arnovananrooij
    Contributor
    Forum|alt.badge.img+5
    • arnovananrooijContributor
    • Author
    • Contributor
    • March 26, 2026

    You should be able to set precisely which fields (attributes) the style applies to. By default, I believe it will apply the defined style to the whole row (feature) 

    I read and write dynamic so I don't know the attributes in advance. I want al the date attributes to be styled like a date, all the timestamps as datetime and all the numbers in non-scientific.

    Community Stats

    32,397
    Posts
    123,141
    Replies
    40,505
    Members
    Terms & ConditionsCookie settingsAccessibility statement
    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.