Export to Excell

[Squal]

Hi,

I have a problem when i try update a excel sheet because array which i export, adds 3 zeros to the values of every cell such as shows in next figure..

Best regards

[Norbert_B]

Your screenshot misses line 2 of the array, so we cannot see the make up of the numbers there. I assume that the second line is the same as the first, but you should confirm that.

It looks like a localization issue to. If your localized OS uses ',' instead of '.' as decimal symbol, it is possible that issues like this occur. Please check your regional settings in the OS.

hope this helps,

Norbert

[Squal]

line 2 of the array is empty:

Localization can't be the cause because in every cells there are 3 more zeros without "," or ".".

  

Also, on another sheet values are exported correctly 

 Best regards

[Norbert_B]

Hm, i am not convinced that it is NOT an ./,-issue.

You have to keep in mind that at least in the US, the '.' is the decimal point where as the ',' seperates "thousands".

E.g. 1M writes as double:

1,000,000.00

Norbert

[Squal]

Ok, i know...but. why adds zeros when reads from excel sheet??? and not in the other way (when writes values)

I did other test: resumen 2D divides by 1000 previously 

This is the result :

 

 Doesn't divide all the cells....

¿?¿?¿

very grafetul 

[RavensFan]

Please post your VI and your .xls file.  Then we can play with it and see what it going on.

[Squal · Accepted solution]

I found the solution: needed to be configured format string parameter in Append Table to Report.VI

by default is  %.3f 

Thanks you very much to all