Saving measurements to an excel table

[Latenite1]

Hi all,

Im trying to familiarize myself with the LabView enviornment before I begin my core engineering classes.  I have made an oscilloscope and have been working through the tutorials, but I dont seem to understand how to save measurements into excel format...here is an example program.

How would I save my measurements of Volts max, min, avg, frequency, amplitude, and peak to peak in the form of 6 colums (maybe 7 for time?).  If i wanted to record these measurements say every second.   Even better I could imagine using a case statement to maybe even choose the frequency of saving points.

I thought the write to measurements would take care of this, but when I open the file Im not clear as to what exactly it's writing/saving?

[JÞB]

post your code.  Good idea to get familliar with your tools!

[Latenite1]

Enclosed is my code.

[JÞB]

---

@Latenite1 wrote:

Hi all,

I thought the write to measurements would take care of this, but when I open the file Im not clear as to what exactly it's writing/saving?

---

Well- its writing "LabVIEW Measurement    
Writer_Version    2
Reader_Version    2
Separator    Tab
Decimal_Separator    .
Multi_Headings    Yes
X_Columns    No
Time_Pref    Relative
Operator    10187
Date    2010/08/16
Time    09:20:19.9139103889465332031
***End_of_Header***    
    
Channels    1    
Samples    20000    
Date    2010/08/16    
Time    09:20:19.9139103889465332031    
X_Dimension    Time    
X0    0.0000000000000000E+0    
Delta_X    1.000000    
***End_of_Header***        
X_Value    Untitled    Comment
    0.587785
    0.599842
    0.611765
    0.623549
    0.635194....

Where the header tells about the waveform and the x-values are listed as a single column (array)

It sounds like you would rather save the measurements that you make on the raw waveform so a *.lvm is not the format you want.

A simple method is to create a header string (column names) from an array of strings and use Array to spreadsheet string and Write to spreadsheet file to write the header.  Then, create an array of your measurements and append them to the same file with another call to write to spreadsheet file.