07-19-2024 07:31 AM
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.
07-19-2024 08:49 AM
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.
07-19-2024 09:38 AM
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.