Skip to main content
  • EN

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

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


Community Stats

30,108
Posts
114,282
Replies
37,742
Members
Terms & ConditionsCookie 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.