Skip to main content
Solved

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

  • January 7, 2026
  • 2 replies
  • 36 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

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,309
    Posts
    122,605
    Replies
    40,012
    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.