LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

how to save data in spreadsheet???

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~

0 Kudos
Message 1 of 15
(2,866 Views)

Hi Mashimaro,

 

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

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 2 of 15
(2,862 Views)

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

0 Kudos
Message 3 of 15
(2,853 Views)

Hi Mashimaro,

 

just play around with those file saving functions:

check.png

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 4 of 15
(2,823 Views)

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

 

0 Kudos
Message 5 of 15
(2,803 Views)

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

0 Kudos
Message 6 of 15
(2,758 Views)

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...

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 7 of 15
(2,754 Views)

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..

0 Kudos
Message 8 of 15
(2,751 Views)

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".

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO, TestStand2016/2019
0 Kudos
Message 9 of 15
(2,743 Views)

 

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..

 

0 Kudos
Message 10 of 15
(2,735 Views)