writing LAbVIEW data to spreadsheet

[Bgmnt]

I have just started with labview.

i wish to write some data from the NI DAQ card into an excelfile continuously while the program executes.

Now, my data is variation of x coordinate with time.

i used the write to spreadsheet block as  shown in the attachment.

however, i am able to create only a .txt file and that too without the time index.

i wish to create excel file with the time and x coordinate data.

also samples are being taken within miliseconds and data must be recorded with that precision.

kindly help

[GerdW]

Hi Bgmnt,

Now, my data is variation of x coordinate with time.

Only as long as you use the blue DDT wire.

After conversion to a 2D array the timing information is lost! (So the problem is your fault. ;))

however, i am able to create only a .txt file

Yes, sure. "excelfiles" aka "CSV files" aka "spreadsheet files" are just formatted text files!

i wish to create excel file with the time and x coordinate data.

Then you need to save the timing information too!

Either use ExpressVIs all the time (there also is an ExpressVI to save data) - or use (the better approach of) no ExpressVIs and learn to program with LabVIEW… 😄

also samples are being taken within miliseconds and data must be recorded with that precision.

Saving with a certain "precision" is duty of the programmer!

As long as you cvreate the correct routines the program will do what you want it to do!

[Bgmnt]

I began working with LabVIEW 5 days ago.

Could you please help me out with the block diagram?

or if not, could you suggest me the way to learn labVIEW?

[GerdW]

Hi Bgmnz,

play with "Write Measurement File" ExpressVI (in the file functions palette)!

To learn LabVIEW:

- NI offers a lot of online FREE resources to learn LabVIEW, start here: www.learnni.com

- LabVIEW comes with a lot of example VIs, found in the ExampleFinder (help menu!)

- LabVIEW has a context help, always keep this window open to read a short description of the function you're working with and to find a link to the more extensive LabVIEW help…