Skip to main content
Solved

Add (attribute)formatting to an excel writer in dynamic mode

  • January 7, 2026
  • 2 replies
  • 44 views
arnovananrooij
Contributor
Forum|alt.badge.img+5

Hi All,

I have a complicated question. I created a custom transformer which can read any table from our Postgres/PostGIS database and write in into a list of desired formats (like Geopackage, Excel, Csv, FileGeodatabase).

I have an issue when writing to Excel. A certain attribute is shown in a scientific notation. Ik know how to solf it in an none dynamic way. I could use an ExcelStyler setting the cstom number format to 0, or add an attribute xlsx_row_formatting or apply formatting to a attribute by adding an attribute <attrName>.formatting. I just can't figure out how to do this in a dynamic mode. I wish there was a excel writer to disable scientific notation, but there isn't. 

Any help or suggestions are appreciated.

 

Arno

Best answer by arnovananrooij

Hi,

I managed to solve it myself. Don't know why it didn't work the first time I tried it, but an ExcelStyler on all the features except the schema feature did the trick!

Thanks,

Arno

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

nielsgerrits
VIP
Forum|alt.badge.img+64

Maybe you are looking for the StringFormatter?

Now I read it again and I think your issue is that Excel defaults to display in scientific notation and I think this is more an Excel than a FME / data issue.

One way to do this is to use python to reformat all columns to custom number format 0. Have not tried this but is the best I can think of.

Buckle your seatbelt Dorothy, cause Kansas is going bye-bye...
arnovananrooij
Contributor
Forum|alt.badge.img+5
  • arnovananrooijContributor
  • Author
  • Contributor
  • Best Answer
  • January 7, 2026

Hi,

I managed to solve it myself. Don't know why it didn't work the first time I tried it, but an ExcelStyler on all the features except the schema feature did the trick!

Thanks,

Arno

    Community Stats

    32,398
    Posts
    122,888
    Replies
    40,119
    Members

    Latest FME

    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.