12-02-2008 03:07 PM
12-02-2008 03:27 PM
Hi GenU1Chevy,
What sort of methodology are you using to populate your spreadsheet? I've seen a few different toolkits and methods, but my favorite is still the "old school" Excel GOOP toolkit. (Hey, it's free!) In that library there's a VI called "excel change active sheet.vi" You can call the sheet (tab) you want either by name or by its number.
One caveat about using this toolikit - sometimes the methods change a little bit from one version of Excel to another. If you get a broken arrow, fixing the error(s) usually entails rewiring an input on an ActiveX property/invoke node within one or more VIs in the toolkit. You only have to do it once and it usually works flawlessly after that. Additionally, the last time I used it was on Excel 2003 and it worked back then, but I haven't tried it on Excel 2007.
If you run into trouble or you can't figure out how to use it I'll do my best to help you out.
Regards,
Jim
12-02-2008 03:34 PM
12-02-2008 03:41 PM
[Laughing] Yep, the versions are pretty old on the toolkit. If it's of any comfort, I just loaded it up in LabVIEW 8.6 to refresh my memory. LabVIEW will probably complain about dependencies on the first launch, but after you resolve the dependencies the first time it should work. Alternatively, you could mass compile it the library after you unzip the file. If you've never done this, go to Tools->Advanced->Mass Compile. Point the resulting dialog to the folder where you unzipped the library, and LabVIEW will do its best to go through, relink everything, and compile it to version 8.5. That will save you from having to go through the dependencies dialog.
As I said before, too, a couple of VIs might be broken due to some funny ActiveX calls, but it's usually nothing terrible.
If you can't get it to work, I can open it up in 8.5 and see what I can do.
12-02-2008 03:51 PM
Oops. I'm on a roll today for spectacular answers. Of course you can't load something that old in 8.5! Sorry about that.
I'll have that recompiled for you in a minute and I'll post it.
12-02-2008 04:05 PM
GenU1Chevy wrote:
Can I use this toolkit on LV8.5? It looks like it only works for 5.1 and 6?????
Alright, once again my apologies. Here it is, recompiled in 8.5.
12-03-2008 08:24 AM
12-03-2008 08:36 AM
You're very welcome. There are a lot of VIs in that toolkit and it might look a little intimidating at first, but usually you only need four or five of the VIs in there to accomplish the usual stuff.
The typical usage goes something like this:
excel open.vi
excel change active sheet.vi
excel read string.vi
excel write string.vi
excel read numeric.vi
excel write numeric.vi
excel save.vi (very important!)
excel close.vi
12-03-2008 08:41 AM