Can I transfer data between Excel and LV of different language?

[helenees]

I used ActiveX method to write data from LV(English) to German Excel. The decimal point format seems to have problems. I wrote data with comma decimal point,the curve is not shown. When I replace ',' with ',' actually did nothing, the curve is shown. In some case, when I try to replace, the data change to integer.
What should I pay attention to in LV to get the right data?

[Thomasg]

Hi!

I played around with your "curve5" and "curve6" for a while. I notice some thing i think is the real problem you have. The valeus are not in the format "1,35" they are " 1,35" (one, two or more spaces in front of the value). So insted of replacing "," with "," you can replace " " with "" (space with nothing) and get the same result. So i think you can start to find out there whose spaces are generated. Some thing you can pay attention to then using LV and decimal numbers is the National alternatives fore your computer in the control panel, so that you are using the same sort of decimal separator in both LV and the computer.

Hope this helped.

/Thomas