LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Output Excel Data for DMM

I'm trying to write a program by using LabView 8.5 to run the NI DMM device. and I would like to record the data and export to excel spreadsheet. however, it gave me error when I use the function of the write to spreadsheet and it said"The 2 terminals were different type". so I'm wondering how to convert the DMM signal to the regular signal which is can read XY value? OR is that any better way to solve this?
0 Kudos
Message 1 of 4
(3,365 Views)

You have not provided enough information. What function are you using to read the DMM and how is it configured? For example, if you are using niDMM Read Waveform, you can select to return a 1D array or waveform data type. What do you mean by XY value?

 

p.s. You should also be aware that the Write to Spreadsheet function does not create an Excel file. It creates a text file that Excel can import.

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

sorry about that!

I'm using the PXI 4072 to measure the voltage. and I also found there is a example in the example finder in LabView is provide the function that I want. so that I would like to add a additional function into the program that it can export the data. the example is "Cont Acq&Chart Multiple Samples.vi" 

I also attach the picture about the program example, I hope it helps to understand. 

 

 

0 Kudos
Message 3 of 4
(3,348 Views)

You are only exporting the very last iteration of the while loop. Right click on the exit tunnel and select ' Enable Indexing'. This will create a 2D array and you will have to change your wiring. Or, place the Write to Spreadsheet function inside the loop. With it outside, the array allocation will cause the VI to run slower and slower the longer you run the loop. If you have it inside, you will slow down each iteration by a fixed amount of time - the time it takes to write all of the samples with each run. You should look at the consumer/producer design pattern.

 

The niDMM Read can also return a waveform data type. If you need the timing information (t0 and dt), you should be using this mode. The Export Waveforms to Spreadsheet File can be used for this.

0 Kudos
Message 4 of 4
(3,333 Views)