LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Excel import data with Report Generation Tool error

Hi everyone.
I modified a code found in the forum (Append Data to an Excel Document Every Iteration Using Report Generation Toolkit) to repeatedly write columns of SGL experimental data into Excel.

I use the comma as a decimal separator.

When the exported values ​​are less than 1, Excel interprets them correctly but as text, forcing me to convert them into Excel itself. When the values ​​are greater than or equal to 1, Excel's interpretation is completely wrong, for example 1.186931 is interpreted as 1,186,931 (data in excel.jpg). Added to this strangeness is the fact that if I export a table that I want to write in Excel from LabVIEW directly to Excel, via the control panel, with this code, the export is perfect (right format.jpg).
Can anyone help me solve this problem?

Thank you.

0 Kudos
Message 1 of 3
(208 Views)

try using a dot as decimal separator. 

It looks like when you use comma, excell interpret it as thousand separator, when the number is bellow 1, it becomes a "text" not a  number. 

the other optin is to save as csv file and open on Excell. But when you transfer labview-excell directly you may run into differences. 

 

0 Kudos
Message 2 of 3
(189 Views)

To use a dot instead comma for decimal works!

And it is enough for me, but I'm wondering why even I set comma as decimal separator in operating system I found that problem.

Thank you, LVNinja.

 

0 Kudos
Message 3 of 3
(178 Views)