how to save data in spreadsheet???

[Mashimaro]

here is the audio analysis with sound card vi, i would like to ask how to save the data in the spectrogram to spreadsheet~
i want to save the data for frequency and the time~
thanks~

[GerdW]

Hi Mashimaro,

in the waveform functions palette you will find the function "Export waveforms to spreadsheet file". Did you try that one?

[Mashimaro]

can u help me solve the vi? 
thanks a lot~

[GerdW]

Hi Mashimaro,

just play around with those file saving functions:

[Mashimaro]

i m trying but i dont know why the peak detector have problem..
it's like this what you mean?

[Mashimaro]

hi again~
do you know how to save spectogram in spreadsheet?
i mean the frequency vs time~

[GerdW]

Hi Mashimaro,

peak detector:

What kind of problems do you see? I don't know the data you supply to that function...

saving spectorgramm:

You're using a chart to display the spectogramm. Either write each line of data to a spreadsheet and prepend a time value as first element OR read the history of the chart (as 2D array) and prepend a time column before using WriteToSpreadsheetFile...

[Mashimaro]

sorry, i don't know much about labview...

what i want to do is, as u seen in the figure, that is the online spectrogram monitoring sound card..
i am using microphone to get the waveform, and at the spectrogram there, i want to save the data in frequency and time..
do you know how??
thanks for your help..

i am using labview 2012..

[GerdW]

Hi Mashimaro,

the attached picture doesn't resemble the VI shown before...

Your spectogram is provided as 2D array. Save that using a WriteToSpreadsheetFile function...

I don't know the two functions you use to create the spectogram, so I can't tell much about the data displayed in "spectogram".

[Mashimaro]

ya, it is different with previous vi,

i want the value for the frequency and time at the spectrogram,
do it possible to save the data to excel,

i want to collect the data, i mean the frequency of voice..