Write in excel table using numeric format with regional point or comma

[jlopez]

I write applications for people around the world in a multinational company, and I have problems with them due comma/point

Write in excel as text is a really disturbing stupid solution. Solution is to write excel sheets in numeric format using local point or comma, then the excel table can be readable at any computer.

[P@Anand]

---

@jlopez wrote:

I write applications for people around the world in a multinational company, and I have problems with them due comma/point

Write in excel as text is a really disturbing stupid solution. Solution is to write excel sheets in numeric format using local point or comma, then the excel table can be readable at any computer.

---

Am not sure what do you mean by this? Do you mean that even if you write in excel sheet you should be able to read it without MS Excel? Where is LabVIEW comes into picture? Please explain

[DFGray]

If you use a localized decimal point, you need to know who your data is going to.  This creates a major problem for collaborations between American and European groups.  There are two good solutions to this problem (both of which are natively implemented in LabVIEW).

1. If you use a text file for data, specify the decimal separator in a well defined field in the file.  This is done in the LVM file format.  You can read and write LVM files using the read and write Express VIs.
2. Use a binary file format.  Whether it is TDMS, raw binary, HDF5, FITS, or whatever, the localized decimal point never is a problem, since the data is binary, not text.  LabVIEW natively supports TDMS and raw binary.