Im trying to program hp4194a any example to export data into computer or plotter

[selvi]

I want to do a programming on impedance measurement HP4194a using Labview. I ve already have the drivers for this instrument. If anyone have a sample program how to export data into excel using this program wiil be a great help for me!

[Johnner]

selvi,

Getting data from LabVIEW to Excel is a general task that isn't likely to be addressed in the context of a particular instrument driver, but you will find literally dozens of pieces of example code for it scattered around the NI Web site. Just go to the NI Developer Zone Example Code Library and search for "excel" or else search these forums for threads mentioning Excel.

Better yet, you can find nice examples that ship with LabVIEW by going to Help >> Find Examples and searching for Excel there. One such example is "Write Table to Excel.vi".

These examples typically write directly into Excel via ActiveX automation, but there's also the lower-tech method of spitting out your data into a "spreadsheet file" (which is simply a tab-delimited textfile). That approach has the advantage that the data is readable by almost any analysis/display application you might choose. Once again, you can find examples for this by searching the relevant example libraries for "spreadsheet".

Hope that helps,
John

[selvi]

I'm trying to program and interface data thru labview 7.1.for HP4194A Impedance analyzer machine. I have the drivers for d machine. This is d first time i'm trying to write a program thru labview If anyone has a sample or example program on array and data exported out to computer will be a great help for impedance measurement. TQ.

[Philip_Courtois]

Here's a small example. This VI will open Microsoft Excel and write an array of random numbers to the active cell (the cell which is selected). This is all done using ActiveX in LabVIEW. The active cell will be the upper left hand corner of the array.

Directions for using this VI:
1) Select to either create a new Excel sheet or open an exsiting one by using the Create/Open Excel toggle switch.

2)Select how many rows and columns that you want to write to Excel.

3)Click on the Open/Create button. This will either open a new Excel sheet or allow you to open an exsiting one.

4)When Excel opens, select which cell you want to write to by clicking on it. You can then minimize Excel and go back to this VI.

5)Click on the Write to Active Cell button. This will write the random number array to whichever cell you selected in Step 4.