Excel Board

[TCPlomp]

Hi all,

Is it about time to start a LV-Excel board?
I have a feeling that some Class courses cover the interaction between LabVIEW and M$Excel, I think 1 out of 2 posts at the LabVIEW board is about communication with LabVIEW and Excel.
So to bundle these questions it might be usefull to dump them in a seperate place!


Ton

[Joe_H]

I would like to contribute to this board, and say it is about time we created this thread.

Here is a toolset that I have compiled over a period of time working with excel.

Also a tip for beginners:

If you do not know how to do it in excel then you probably will not figure it out in LV either. So my suggestion would be to read the excel help and figure out how to do it. Then record a macro of what you want to do and then duplicate the macro in LV using methods and properties. 

[TiTou]

---

Jhoskins a écrit:
Also a tip for beginners:

If you do not know how to do it in excel then you probably will not figure it out in LV either. So my suggestion would be to read the excel help and figure out how to do it. Then record a macro of what you want to do and then duplicate the macro in LV using methods and properties.

---

That is quite a sensible piece of advice, I did try to do in LV something that I didn't know how to do in XL and had to give after loosing a couple of hours
Now I try be more humble.

More about the this thread, no doubt that an Excel board would get packed with loads of post quite fast, that's for sure !

And thanks a lot Joe for sharing your code !

[tst]

I wouldn't count on it. The NI forums have a rather rigid structure which does not support moving posts from board to board. The LV-Excel interaction is by no means significant enough to warrant a whole board. NI apparently doesn't like making big changes and even much more important things don't get a board.

You can either create a thread where links to Excel interaction stuff will be concentrated (like this one) or you can post your examples to the new community site.

[Joe_H]

This message talks about freezing panes in excel.

Freeze panes

[shoneill]

Personally, I alays try to link Macros with LV code so that I can get the best of both worlds.

Data processing in LV, Copying, Pasting, graphs and so on in Excel via Macros.

Works for me.

I still wich NI would introduce a text-based ActiveX interface possibility so that ActiveX routines in LV wouldn't take up so much space.....

Shane.

[Joe_H]

Here is another board that talks about page setup in excel

[Joe_H]

I have another VI to add ttothe list. this VI allows you to print a worksheet, view print preview, and select # of copies to print.

[Joe_H]

Here is a discussion where i posted some VI'S that will do a search and replace and a "find"

Here are the VI'S

[TiTou]

Just to add to Joe's post, the Replace.llb is now also available in LV 7.1 at the same thread, a couple of post after the LV 8 version 😉

Thanks Joe !