Skip to main content
Solved

Excel writer: Number stored as string

  • April 13, 2016
  • 1 reply
  • 91 views
P

Hi guys,

I transform a CSV file to excel inside an FME workbench to calculate some statistics. Everything goes smoothly, the only problem is that when writing to Excel, all numbers (decimal numbers mostly), are stored as text.

Is this a known problem, or does somebody have an idea how to have numbers in excel that are stored as numbers?

Thanks,

Maxime

Best answer by phatnine

I found the answer. I just needed to modify the type of the attributes in the writer feature type property and set it to NUMBER.

I though since it was set to auto it would be ok.

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.

1 reply

P
  • phatnine
  • Author
  • Best Answer
  • April 13, 2016

I found the answer. I just needed to modify the type of the attributes in the writer feature type property and set it to NUMBER.

I though since it was set to auto it would be ok.

Community Stats

32,154
Posts
122,047
Replies
39,812
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.