excel read and write to labview

[Jack Bristow Jr.]

Hi Hacky

thanks! it helps a lot. but right now i have another question. can a data in time domain that is saved in excel be read back to the labview and perform the FFT waveform?

[Hacky]

Hi Jack,

its the similar way. Look at the demo ....

When you create (by LV or by Hand) a spreadsheet that contains for example 100 cells of data A1 to A100

you can import this by Read Spreadsheet.vi. You need to transpose the array, if you don´t the arrangement

is expected in rows instead of columns. Just try it with the demo i wrote.

Regards, Hacky

[Jack Bristow Jr.]

thanks..i now know how to retrieve data from excel to labview and graph it.

can you suggest what i must do to compair 2 FFT waveform or data and to display result in text e.g. loose spark plug, broken ring etc.

[Hacky]

Hi Jack,

no good idea on that but:

imagine comparing two real numbers for equality, you cannot do this via ==.

I assume, if the scaling of your x axis is equal in both signal you can easily subtract them. The result is an array with very low values.

Using array minmax you can check for boundaries.

When your scaling on the y axis is really different an you look just for peaks you can normalize both arrays and subtract them.

for more complex tasks you shuld post the question again with a new title for analysis guys.

Regards Hacky