topic gpib data to spreadsheet in LabVIEW

gpib data to spreadsheet

alphakwk — Thu, 17 Feb 2005 15:26:18 GMT

Hi
I have problem trying to convert data from a lock-in amplifier via GPIB into readable spreadsheet.
How do i go about solving it.

Cheers

Re: gpib data to spreadsheet

JRA — Sat, 22 Nov 2025 01:44:06 GMT

Once you've read the data into your LabVIEW application, it's just like sending any other data into an Excel spreadsheet. This article [broken link removed] on ni.com talks about it. You have two options:

Free but more coding required: Use the ActiveX VIs in LabVIEW to communicate with Excel. Here [broken link removed] is an example where someone communicates with Excel via ActiveX. There are also other examples of doing this in the examples directory (examples\comm\ole-excel8.llb).

Less coding but not free: You can use the LabVIEW Report Generation Toolkit for Microsoft Office. This toolkit has VIs which handle all of the ActiveX communication for you. It makes it much easier to do. This tutorial on ni.com describes how it's used.

Hope this helps out. Good luck with the program!

Re: gpib data to spreadsheet

Dennis_Knutson — Thu, 17 Feb 2005 15:43:52 GMT

What exactly is the problem you're having? The simplest way to do it is to use Write to Spreadsheet File. It will take a 1D or 2D array of data and write it as text file that can be read by any spreadsheet program. Posting an example of your code, data you're trying to write, or details on your problem would help get you some a more specific answer.

Re: gpib data to spreadsheet

JRA — Thu, 17 Feb 2005 15:47:26 GMT

Actually, just realized something. You may not even want to write to Excel! In that case, you can just use the standard report generation VIs. I would suggest doing it that way as:

1. You don't have to mess with Excel
2. It's free!

In this case, there are, I believe, quite a few examples you can go buy. If you know what type of data you're writing (string, numeric, etc), I'd be glad to help you out.

Re: gpib data to spreadsheet

Sheldon_Stokes — Thu, 17 Feb 2005 16:16:49 GMT

One problem that the write to spreadsheet file has (in it's stock form) is that it only puts numeric data into a delimited text file. I do a whole lot more work with text files as run logs and such, where I have a few numeric columns and a few string columns. I have ended up writing my own log file utilities, but the original "write to spreadsheet" VI can be modified to take in all string data rather than numeric data, but the issue still remains that the routine takes only one type of data as an input.

Sheldon