topic Re: Excel Board in BreakPoint

Excel Board

TCPlomp — Fri, 16 Jun 2006 11:13:16 GMT

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

Re: Excel Board

Joe_H — Fri, 16 Jun 2006 12:52:14 GMT

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.

Re: Excel Board

TiTou — Fri, 16 Jun 2006 13:56:23 GMT

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 !

Re: Excel Board

tst — Fri, 16 Jun 2006 14:12:25 GMT

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.

Re: Excel Board

Joe_H — Mon, 19 Jun 2006 14:53:09 GMT

This message talks about freezing panes in excel.

Freeze panes

Re: Excel Board

shoneill — Tue, 20 Jun 2006 14:29:34 GMT

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.

Re: Excel Board

Joe_H — Tue, 11 Jul 2006 18:16:54 GMT

Here is another board that talks about page setup in excel

Re: Excel Board

Joe_H — Fri, 28 Jul 2006 15:55:37 GMT

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.

Re: Excel Board

Joe_H — Tue, 15 Aug 2006 14:00:13 GMT

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

Re: Excel Board

TiTou — Thu, 17 Aug 2006 07:02:04 GMT

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 !

Re: Excel Board. Modifying rows of the same excel sheet, number of times without touching data already present (numbers and strings)

TeaAndBiscuits — Tue, 26 Sep 2006 17:39:53 GMT

File attached....

Have gone thru FAQs and examples. (And also 4 parts of 'Creating a Report in Microsoft Excel Using the LabVIEW Report Generation Toolkit'. Unfortunately this document is not clear enough for me.)

Have task of modifying rows of the same excel sheet, number of times without touching data already present (numbers and strings)

I have an excel file. (attached)

A test will be run N number of times. (n and N<=17)
SubTask 1 --> Each time it runs, string data needs to be placed in 'n'th row. (...there are going to be notes in Row 18 and row 19)
SubTask 2 --> Each time it runs, a 1D array data also will be placed in the same row (but in different cells)

SubTask 3 --> The number 'n' of the row (where to place the current iteration's data) needs to be determined on fly (by looking at "n-1"st non blank row)

The same file needs to be used.

How can above be achieved ?

thanks

Sandeep

Re: Excel Board. Modifying rows of the same excel sheet, number of times without touching data already present (numbers and strings)

Joe_H — Tue, 26 Sep 2006 17:48:56 GMT

I'm sorry sandeep but you will have to post this question in the Labview or appropriate forum. This board shall only be used to link to a discussion thread or to post VI's that already do a specific task.

Thank you.

Re: Excel Board. Modifying rows of the same excel sheet, number of times without touching data already present (numbers and strings)

Will.D — Wed, 15 Nov 2006 17:21:30 GMT

Here is a very handy piece of advice for anyone who is unsure about how to do something in Excel with ActiveX.

Re: Excel Board. Modifying rows of the same excel sheet, number of times without touching data already present (numbers and strings)

Will.D — Fri, 01 Dec 2006 16:20:10 GMT

Here are another few useful pieces of advice on Excel and ActiveX.

Points of note: Ensuring that you close all references in the reverse order of opening them

"Note that any function which returns a reference opens a new reference (Ranges need to be closed too)" - seems obvious, but I missed it until I read this.

Thanks to Steven and Shane for the info.

Programmaticaly Get Next Cell Index of Excel Sheet

Ben — Tue, 05 Dec 2006 13:39:53 GMT

In this thread

http://forums.ni.com/ni/board/message?board.id=170&message.id=218543&a#M218543

Michael Monroe shares another method that lets you do this!

Ben

BTW Michael has posted many MS office type solutions. If you can't find what you need in this thread, search through Michaels postings.

http://forums.ni.com/ni/view_profile?user.id=7764

PS: Great work all on putting this thread together!

Message Edited by Ben on 12-05-2006 07:40 AM

Selecting a worksheet in Excel

Ray.R — Tue, 05 Dec 2006 14:00:58 GMT

Here is a nice description on how to select an existing worksheet either by index (number) or by name:

http://forums.ni.com/ni/board/message?board.id=170&message.id=135193

Grpaphs in Excel

Ben — Wed, 06 Dec 2006 00:55:34 GMT

In this thread David Crawford posts an example using VBA with Excel from LV.

http://forums.ni.com/ni/board/message?board.id=170&message.id=218856&a#M218856

Ben

PS Nice to see you back LJV.

Message Edited by Ben on 12-05-2006 06:56 PM

Re: Excel Board

tst — Tue, 23 Jan 2007 09:24:12 GMT

I haven't used it, but you can find an Excel toolkit here.

Re: Excel Board

Joe_H — Mon, 12 Feb 2007 23:17:15 GMT

Here is a post where i give an example of inserting a row into an excel file.

Re: Excel Board

Nghtcrwlr — Mon, 19 Feb 2007 22:06:23 GMT

Hello

Can anyone help me in copying the contents of a cell in Excel and paste to the a wrod document. With the VI in the above message i was able to get the contents in a cell in excel , but as a table. When i directly connect the output from array to spreadsheet string to a specific position in word it does not work. Can any one help?[ I have attached the vi for it below]