Measurement data and putting it in 2 diffent columns

[jszarra]

Regards,

I am working on this vi, and it works, it is almost finished. It takes the data from measures made by AGILENT 4980a, and put it on an excel file. The instrument always measures 2 variables. Im able to plot the 2 variables with LabVIEW, but I want to export both to the excel file. Im able to take the first measurement, and put it on excel. Actually, I can do it with the 2nd, but I cannot do it with both at the same time.The only thing that I need, and I dont know how to do it, is to take the second measurement data, and put it on the second column of the excel file. Any suggestion would be awesome!. Thanks very much!

PD:

The first vi attached is the program im trying to upgrade and the second vi, is the one that I use in home, where I dont have the equipment to make tests.

[Albert.Geven]

Try this

I don't know exactly how the office toolkit works, but now you have a 2d array of data and not a while anymore and a nicer looking (readability) program.

2 questions:

1) why do you use a while and especially why a timed loop?

2) why did you use initialize array for only one element?

Message Edited by Albert Geven on 03-06-2010 03:07 PM

[jszarra]

Thanks for your suggestion Mr. Albert. The reason why I use a  Timed Loop is because the original vi that im using with the equipment, only makes one measure, so in this one that I made, I can adjust the time of the measurement, and take one sample per second (for example, a 10 seconds measurement is goint to take 10 samples). Actually, this is one of the things I would like to improve in the future, because I dont know too much of LabVIEW. Later, I would like to adjust the frequency of measurement, and that kind of things, but for now, 1 sample per second is ok. For the second question, I really dont know. See, this vi I build it using examples and suggestions by other people. The truth is that I dont know labVIEW too much (I do want to learn it, and eventually Im going to have to do it, because Im going to purchase a DAQ from NI and make some routines with LV).

Mr. Albert, Im using LV 8.6, i cant open your vi. If you are able to save it for use in an older version, it would be awesome. Thank you so much sir!.

[Albert.Geven]

Look at my implementation, and if you have questions go ahead

here is the 8.6 version, sorry I did not check the version

[jszarra]

Thanks for your concern Mr. Albert. I see that you used a For Loop for taking all the data and put it on an excel table. Unfortunetly, I acquire my data in real time, so I cannot, or I dont know, use that kind of loop. What I ended up doing, is making a new Excel Report for the 2nd variable that I measure, so I have two different excel books, generated at the same time, each one with one variable. At the moment, I dont know how to make a table with the 2 variables in different columns. Thanks sir!

[Coamín]

Hi jszarra

I think that you only need to use the VI Append Table to Report.

Here is an example.

Best Regards.

Coamín Cruz.

NI México