Fill excel file with FFT data

[P1GOU1]

Hi people !

I have trouble for fill spreadsheet with data who come from my vi.

The aim is to see on excel the same graph than my VI graph FFT.

Despite my search impossible to find a working method to do that.

Join to this post, spreadsheet with my raw data after record.

FFT graph view :

VI view :

See you very soon !

[caillotantoine]

Hi P1GOU1, 

Here is a simple VI that get the FFT from a waveform and load it into a CSV file (you can just select your file as you want depending if you have the repport generation toolkit or not). 

Here is the result: 

If you are french and using a french version of Excel, here are some points you might strugle with:

the separator is a ; not a , 

the point in floating number doesn't work, we need a comma. [Ctrl-h] to find every point and replace with a comma worked perfectly on my side. 

Best regards,

A. CAILLOT

[altenbach]

---

@caillotantoine wrote:

Hi P1GOU1, 

Here is a simple VI that get the FFT from a waveform and load it into a CSV file

---

You probably want to use the actual f0, and df to generate the frequency (x) values of the first column.

[caillotantoine]

Indeed, it depends on the waveform. However, in this case, it is not needed and the frequency is already correct. (sinewave at 440Hz is already found at 440Hz). 

[P1GOU1]

It's impossible for me to view correctly my graph in excel with your method 😞

My waveform is a periodic square signal, of 1Hz (signal of test).

[caillotantoine]

Hi P1GOU1, 

may you show us your result and your code? 

Thanks, 

Antoine

[P1GOU1]

Hi !

Here my code :

And, my datas results in attached file.

Ty Antoine !

[caillotantoine]

Hi P1GOU1, 

I had a look, it doesn't seem so wrong. 

By the way, I advice you to use the FFT power spectrum in Waveform>Analog Wfm>Measurements. 

here is my code (in 2012 format, I don't know your LabVIEW version) and my result.

Best, 

Antoine

[P1GOU1]

You can see graph fft on excel with your results ?

If you can, could you show me ?

[P1GOU1]

Hi Antoine !

Ok the problem for see my graph was in Excel setup, it's ok now ty.

My aim now is to save higher fft harmonic (frequency and magnitude) for each acquisition in Excel spreadsheet in two column, so one line by acquisition.

But i'm big noob for generation report.