LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

only one column,when saving 2D Array in csv file

Hi every one,

 

the problem is, that when I save the 2D array data in a csv file, there will only one column, and this column include all the single value of each signal. See Picture.

But after searching, I've found people just wrote the program the same way I do. What's the problem. 

 

PS: the values are germany format, comma instead of point, and I'm sure it disturbes nothing.

 

So appreciate your favour.

best regards

Melo

 

CSV_failed.JPG

0 Kudos
Message 1 of 4
(3,727 Views)

Actually, your comma for the decimal should be exactly the problem.  Change your delimiter to be a tab, save the file as a txt, and Excel should understand it just fine.


GCentral
There are only two ways to tell somebody thanks: Kudos and Marked Solutions
Unofficial Forum Rules and Guidelines
"Not that we are sufficient in ourselves to claim anything as coming from us, but our sufficiency is from God" - 2 Corinthians 3:5
0 Kudos
Message 2 of 4
(3,718 Views)

Hi Crossrulz,

 

thank you for your answer, but the problem occurs when I put a 2D string array. And the .csv file is customer wanted. Is there any other way?

 

best regards

Melo

 

 

CSV_failed02.JPG

0 Kudos
Message 3 of 4
(3,676 Views)

Hi melonetern,

 

placing 'sep=,' as the first line of your csv file will automatically tell Excel to use that character as the separator.

E.g.

 

sep=,
a,d,v
s,f,c

0 Kudos
Message 4 of 4
(3,661 Views)