LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Labview to Excel: Exporting the data

Dear All, 

 

I am currently working with Labview 8.5, a PCI 6254 card and a BNC-2120 connector accessory. 

 

I am trying to aquire a continuous voltage (10000 sampling frequency) and export the data to Excel. I would like one row with the values of the measured voltage and one row with the time it was measured. 

Here is what I have done so far, unfourtunatly I have three rows in Excel, and I have no idea what the first one refers too. The second row seems to correspond to my data and the third one to the time. 

Can anyone help me? Thank-you

Kind regards, 

 

AlexandraMON VI.jpg

0 Kudos
Message 1 of 4
(3,214 Views)

Greetings, from the looks of it, you are multiplying the entirety of the data by the amplification factor, which will mess up your time. You might want to read the detailed help about the "Get Waveform Components" function, it tells you everything you need to know about what is delivered in the output. You might want to first use the DAQ assistant that automatically delivers a timestamp with each sample to familiarize yourself with the data, before using the DAQ building blocks.

0 Kudos
Message 2 of 4
(3,206 Views)

Look at this thread.

 

Ben64

0 Kudos
Message 3 of 4
(3,193 Views)
I think I understand what you were trying to do. The problem is that the data structure for a waveform is an array (the data) and two **scalar** values. One (T0) is a timestamp showing the clock time associated with the first sample and dT which is the floating point number of seconds between samples.

If you want an **array** of time stamps, you will need to process those two values in a loop that runs once for each sample in the array. Inside the loop you calculate the output time stamps by multiplying dT by the loop count and adding it to the T0 timestamp.

Mike...

Certified Professional Instructor
Certified LabVIEW Architect
LabVIEW Champion

"... after all, He's not a tame lion..."

For help with grief and grieving.
0 Kudos
Message 4 of 4
(3,183 Views)