How to convert your data into a CSV file?

[engineer2450]

I got an XY plot of signals from two funciton generators.  I have basically made an oscilloscope with labview.  I wish to be able to have a csv file that stores the number of times the function passes over a point.

i.e (for a y = x^2 function)

1,0,0,0,1
0,1,0,1,0
0,0,1,0,0

any suggestions?

[altenbach]

Lets assume you have your data as a 2D array of numbers.

You can just use "array to spreadsheet string" with a comma wired as delimiter. This will give you a spreadsheet string that you can write to a file and display in a string indicator.

You can also go directly from the 2D array to a file using "write spreadsheet file". Again wire a comma as a delimiter.

[engineer2450]

Thanks for the input.  I was wondering if there are any websites where I can download VI's that can help with reading data and directly importing them to excel files?

[Dennis_Knutson]

What about http://forums.ni.com/ni/?

[engineer2450]

haha i am already familar with that website... looking for others

[Dennis_Knutson]

I just did a search for Excel in the LabVIEW board and came up with 6454 hits. There are more in the Developer Zone and there are more in the Excel Board. There are also the shipping examples, the Write to Spreadsheet File, Write to LabVIEW Measurement File, and the Report Generation Toolkit. If you want to try a different forum, there is Lava but I believe you can find anything you want to know right here. What exactly are you trying to do that wasn't already answered?

[engineer2450]

altenbach mentioned "Lets assume you have your data as a 2D array of numbers."

when as of right now... I got a graph, so I should convert the data from the x and the y into arrays... and then try to convert the array's data in excel or csv?

[Dennis_Knutson]

You realize, don't you, that you can wire the output of the DAQ Assistant straight to the Write LabVIEW Measurement File and it will create a csv file if you choose that option?

[engineer2450]

I found a VI that can help me write csv's 😄

[ST5]

Attention with a Labview generated csv file, when afterwards opening and saving, even without changes with Excel.

Even when written as 2D text array, Excel automaticly converts text like 5e-1 to something else.

In my case, the text "5e-1" wasn't representing a number, but a code representing an adress with pointer in a temp controller.

It caused a huge bug. Now I always start with a Char, different from E to be sure it will be interpreted in excel as text

Attention also when using , and . in some language keyboard layouts and default settings.

They are not necessary everywhere the same in windows excel and labview.

.