How to write output from Keithley 220 to Excel using Labview

[rachel-d]

Hello, I have seen other posts that ask this question and was wondering if anyone has found the solution? I have downloaded the driver and seem to be able to communicate with the instrument. However, I am not very sure how to modify the driver to set the amperage and record the output to Excel.

[Adam W]

Hi rachel-d,

It looks like that instrument driver is only one VI, and is not a certified driver.  There seems to be a control for "source (A)" which may be what you're looking for as far as setting the amperage.  Honestly, you may have better luck starting with a simple GPIB communication program and writing your own VI.  You may need to check your device's manual for information on specific commands to set current values, etc.  As for excel, you could use the Write to Measurement File Express VI and write your data to a text-based measurement file (.lvm) that is tab deliminated.  You can then open this file with Excel.  There are also examples you could look at in the NI Example Finder (Help > Find Examples).

Hope this helps!

Adam W
Applications Engineering
National Instruments

[DuffmanSays]

Hello Rachel,

Once you can manage to get your data into LabVIEW, it is not difficult to write it to a tab delimited file that can be read by excel. As Adam mentioned, you can use the Write to Measurement express VI to write in .lvm format. This is the easiest method to use with the dynamic data type that is returned by any express VI. If you'd like at bit more customization for the layout of your spreadsheet data, you can take a look at the Write Spreadsheet File VI. Using this VI, you can write a 2D array of data that would map directly to cells in Microsoft excel. I hope this information is useful for you. Please post back if we can provide any additional assistance. Thanks!

Mike D.
National Instruments
Applications Engineer