excel read and write to labview

[Jack Bristow Jr.]

can anyone help me.

I have these following problems:

1. how to save my FFT graph into data?

2. how to get my data after tab delimited it into excel file from labview?

Henry

[LV_Pro]

Hi,
    In trying to open your file there are a large number of sub-vi's that aren't in the standard distro. Could you do a "Save with options",

"Development distribution" and send the resultant ".llb" file? As far as what you are trying to do, without seeing your code I will hazard a guess. If your data is in the form of an array, either 1D or 2D you can send it into the "Write to spreadsheet file" found in the "File I/O" pallette, read it back in with the matching "Read from spreadsheet file". Both of these functions allow formatting the data and the read returns a 2D array.

Arvin Sloan Jr.   😉

P.M.

[Jack Bristow Jr.]

hi!

this is the saved data i get. i don't understand other things you want me to do. sorry i'm a newbie here, pls. have patience. tnx.

actually i'm using labjack as my hardware that's why i'm using their vi's.

[Will.D]

To show what LV_Pro was saying, here's what he mentioned to use.  Have a look at the picture...  use those vi's to write to a spreadsheet file.

[Jack Bristow Jr.]

Thank you Novatron but i know that already, but what i don't understand what LV_Pro said is to make "Save with Option" and :"Development Distribution"

Henry

[Hacky]

Hi Jack,

please deliver the complete SUB VI structure to make anyone able to test it.

File - Save with options - development distribution

Regards, Hacky

[Jack Bristow Jr.]

there you go...thank you for a clear instruction.

[Hacky]

Hi Jack,

since i didnt have analog data acquisition i modified the missing AI part (which is located in vi.lib

to give me an array of 4 x 600 random numbers to get it work.

ok, i see that you acquire continously data. when you put this to an .csv file you will get a lot of ffts.

is it this you want or do you want a snapshot of your fft at a time?

regards hacky

[Jack Bristow Jr.]

actually the data i'm saving is in time domain, i want to save in FFT, can i save my data in frequency domain? if i can how do i do that? and also how to use the read spreadsheet vi and write spreadsheet vi? tnx..

[Hacky]

Hi Jack,

i prepared a small demo showing how to handle FFT and Spreadsheet files.

Take care because my setup is german. we have comma instead of point.

good luck, Hacky