Skip to main content
Solved

Excel writer: Number stored as string

  • April 13, 2016
  • 1 reply
  • 65 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.

View original
Did this help you find an answer to your question?

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.

Reply


Helpful Members This Week

Community Stats

31,341
Posts
118,860
Replies
38,931
Members

Latest FME

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.