Need simple example for writing to Excel

[spaceman_spif]

I've browsed some of the examples on here of past questions regarding working with Excel, but for some reason I'm unable to open the examples, or they download but are missing a few key sub-VI's when I view them.

What I would like is a very simple example of how to write a chunk of (any kind of) data into a specific cell in Excel.  I'm working with version 7.1

[PJS]

Two questions

1. What level of LabVIEW do you have?  Base, Professional or Full?
2. What version of Excel are we talking here?

[spaceman_spif]

1.  I have....ummmm...whatever the guys here gave me to work with.  I think it's the Full System cuz the label on the box of discs says "FDS".

2. Excel 2000.

[spaceman_spif]

Several Excel examples in LabView use this tool that I've attached, and when I search my tool palette, I can't find it anywhere. 

Likewise, if I right-click on it and select "Help" it gives me a page saying "This page can not be displayed".  What is this mystery tool??  Why are they hiding it from me??  Who did I upset??  How do I seek forgiveness??

[PJS]

you should be able to use the example from:

http://sine.ni.com/apps/we/niepd_web_display.display_epd4?p_guid=B45EACE3DD9C56A4E034080020E74861

Other than the fact that I have excel 2003, the VI opened fine and when I modified the properties to match the 2003 API, the VI functions fine.  If you are missing things when it opens, please shoot a screen capture and post so we can see what is missing.  It requires the full development package although, to be honest I am not sure why by looking at it.

It was written in 5.1 and I have 7.1.1 Pro

[PJS]

It is an automation close, although you can substitute the ref num close...hmm I wonder if that is why I have to explicitly close Excel via method node....Even the extended help is broken on it.  But hey, in your luck.  the example I posted does not use it.

[Travis_M.]

Hello All!

Yes, that VI that is missing in the attached VI is an automation close VI.  This VI was not included in the Functions Palette after LabVIEW version 6.1 (hence you will not be able to search for it in LabVIEW 7.x).  If you have an example that uses it, you should still have it available for use, but you might want to replace it with the "Close Reference" VI which will perform the same action.

Another important question that has not been asked is which OS are you working with?  ActiveX functions are unavailable for any OS that is not Windows.  If your version of LabVIEW is the Full Development System and you are on a Windows machine, you should have no problems with that particular VI unless your installation has some abnormalities.

Thanks for posting, please let us know if you have any other problems with this VI, or if I have not answered your questions completely.

Regards,

[PJS]

LabVIEW base does not support active X?

[Travis_M.]

Hello all,

My apologies!!  LabVIEW Base DOES indeed support ActiveX (compare here).

Please let us know if anyone is still unable to locate those VIs listed in the above conversation.

-Again, sorry for any confusion.-

[Joe_H]

Here are some vi's that will help you out. Also you can look at an example in  the example finder called write table to excel. If you need any more help just let us know.