How to write data acquired by DAQ Assistant in Labview 7.0 to spread sheet?

[Segarally]

I have a PCI-6023E card and four channels: one load cell, three LVDTs. I want to use the DAQ Assistant vi in labview 7.0 for data logging. The question is how to write the data from the four channels together with time stamp into spreadsheet file at the same time?

[Herbert Engels]

The easiest way of doing that is to use the "Write LabVIEW Measurement File" VI. By default, this will write a header section for each execution, but you can limit that to one or no header. You can also choose to write one timeline per execution or one timeline per execution and waveform etc.
Besides that, you can use the "From DDT" VI to split data up into waveforms or double arrays, but that would leave implementing the formatting to you.

[Gram]

I have similar problems. I just want to output accuquired data along with time stamp, which is absloute time, to srpeadsheet. If I do not use experss VI, how can I do it? Many thanks.

[TylerS]

apotentialuser,

Here is a link to another discussion forum post that addresses your question. Some of it deals with writing to a text file, but there is a good entry about writing to a spreadsheet file.

http://forums.ni.com/ni/board/message?board.id=170&message.id=13256&requireLogin=False

Tyler S.

[Gram]

Tyler S,

Thanks a lot. The information contained within the link basically solves my problems. Another stupid question: If I continuously acquire data (timed acquisition with hardware clock used to control the acquisition rate, other than software polling technique), can I get similar solution?

I understand that acquired time can be derived from the scan rate prescribed. However, it is difficult to get the exact start acquisition timing. Could you and anybody else advise on that.

[AnujD]

There are no stupid questions!

Here's a great link that helps describe the timing information done with our data acqusiton waveforms.

http://digital.ni.com/public.nsf/websearch/5D42CCB17A70A06686256DBA007C5EEA?OpenDocument

Regards,
Anuj D.

[Gram]

Many thnaks, Anuj D,

Thanks for the info. which is very helpful to me.

Probably I just output columns of data without timing stamp. I can add another column of timing informaiton manually in the spreadsheet at a later time, because I can have only one time stamp for a finite acquistion.

[Gram]

Another question:

If I acquire a set of time history data and then transform them into frequency domain via, say, FFT Power spectrum.vi, how can I also output the power spectrum data to a spreadsheet?

Thanks in advance.

[AnujD]

You would still use the Write To Spreadsheet file vi as explained earlier in the thread. The only other thing you would want to do is add another dimension to your 2-D array using the Build Array vi. One dimension will be time, the other your Y data, and another your FFT data.

Hope this helps,
Anuj D.

[Gram]

Thanks a lot! I will try according to your comments.