programmatically create graph in excel

[nt387]

Hello,

I am trying to get an array of data into excel and graph it (using excel) through LabVIEW. I have found this resource: http://www.ni.com/newsletter/51339/en/   It is the second to last method. However I do not think I have the excel specific VIs. Is there an easy way to get that palette, or if not is there an alternative method to do what I want to do?

[Dennis_Knutson]

An easy way to get the functions is to purchase the toolkit. The last method shown on the page you linked is what is happening under the hood of the toolkit. The code is provided in the form of a snippet. Have you tried it?

[Mitchum]

I am not familiar with the different bundles and packages of LabVIEW.  Having said that, access your quick-drop function (ctrl+space bar) on the block diagram and type in "ActiveX".  I only took a peek, but I believe many of the items I saw on the resource you linked is available as an ActiveX property or invoke node (ApplicationClass, workbook, sheet, cell, etc).  If nothing comes up through your quick-drop, then I guess that means your LV doesn't come with it?

I can finally answer a question semi-properly.  Cheers!  I had fun recently messing around with the ActiveX stuff to manipulate Excel VBA's.

-Mitch

[Jeffrey_Zola]

I, too, used the ActiveX VIs in an application to invoke Excel macros that imported tab-delimited files into spreadsheet templates and then updated various pivot charts. It took a little patience to "reverse engineer" the examples linked in the help, but I got it to work. It requires that you have a working VBA script, so the work is not just in the LabVIEW program. 

Delivers a satisfying final presentation of data acquired by a LabVIEW application that allows for further manipulation in Excel, as required. Also allows for easy transfer of graphs & tables to Word documents.

Jeff Zola

---

@fumobs wrote:

I am not familiar with the different bundles and packages of LabVIEW.  Having said that, access your quick-drop function (ctrl+space bar) on the block diagram and type in "ActiveX".  I only took a peek, but I believe many of the items I saw on the resource you linked is available as an ActiveX property or invoke node (ApplicationClass, workbook, sheet, cell, etc).  If nothing comes up through your quick-drop, then I guess that means your LV doesn't come with it?

I can finally answer a question semi-properly.  Cheers!  I had fun recently messing around with the ActiveX stuff to manipulate Excel VBA's.

-Mitch

---