Skip to main content

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