Controlling Excel from LabVIEW

[Gorka Larrea]

I'd like to control Excel from LabVIEW, and have started
using ActiveX. But the only thing I have done is open
Excel, create a workbook and add worksheets. Has anybody
got any examples or information I've missed? I'm not able
to insert data from an array, or use the save as
property... Is ActiveX allways so complicated?
Thanks in advance and best regards.

Gorka Larrea
glarrea_1@hotmail.com


* Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful

[Tims]

Hi Gorka

Have you tried looking at the examples in LV? There is an example that puts the data from an array into an Excel spreadsheet.

Tim

Gorka Larrea wrote:

> I'd like to control Excel from LabVIEW, and have started
> using ActiveX. But the only thing I have done is open
> Excel, create a workbook and add worksheets. Has anybody
> got any examples or information I've missed? I'm not able
> to insert data from an array, or use the save as
> property... Is ActiveX allways so complicated?
> Thanks in advance and best regards.
>
> Gorka Larrea
> glarrea_1@hotmail.com
>
> * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful

[Gorka Larrea]

Well, now I've looked at the NI examples understand this a
little more, I've achieved some success but I still can't
for example, format my cells from LabVIEW. Any point on
this? Any examples anywhere?
Thanks in advance and best regards

Gorka Larrea
glarrea_1@hotmail.com


* Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful

[Reinis Kanders]

http://www.easymacro.com/index.htm
Take a look at that tool.


"Gorka Larrea" wrote in message
news:1eea66e4.c74818a7@usw-ex0109-068.remarq.com...
> Well, now I've looked at the NI examples understand this a
> little more, I've achieved some success but I still can't
> for example, format my cells from LabVIEW. Any point on
> this? Any examples anywhere?
> Thanks in advance and best regards
>
> Gorka Larrea
> glarrea_1@hotmail.com
>
>
> * Sent from AltaVista http://www.altavista.com Where you can also find
related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is
Beautiful




-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----
== Over 80,000 Newsgroups - 16 Different Servers! =-----

[Gorka Larrea]

Easy Macro is good, but as long as I tried the demo a while
ago, I realized that it was for LabVIEW 5.1 and I'm still
running version 5.0.1f1, as the project I'm preparing is a
single one with no more use of LabVIEW in the future, I
can't even think of buying anything for this. If someone
could give me some advice I'd be very happy.
Thanks for all

Gorka Larrea
glarrea_1@hotmail.com


* Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful

[Alex]

glarrea_1@hotmail.com (Gorka Larrea) wrote in
<00fa3dc4.6da79dda@usw-ex0108-062.remarq.com>:

>Easy Macro is good, but as long as I tried the demo a while
>ago, I realized that it was for LabVIEW 5.1 and I'm still
>running version 5.0.1f1, as the project I'm preparing is a
>single one with no more use of LabVIEW in the future, I
>can't even think of buying anything for this. If someone
>could give me some advice I'd be very happy.
>Thanks for all

What is it that you want to do. I have some VI's that may be of help.

The problem I have found with controlling Excel is that the automation
control of the appliation is subject to the robustness of Excel. For
example I have attempted to open Excel in an easy manner (open, do, close)
but ha
ve had to add a 5 second wait between calling Excel several times in
this easy access mode, to give it "time to recover". This irritates me, but
I cannot find a way around it. Accessing it "once" to do several tasks
seems to work better (so called advanced mode).

My general advice is to look at other ways of approaching the same problem.
Writing TAB delimited text files is good. I think that HiQ control was also
included in 5.0 wasn't it. Perhaps HiQ is better for a once off project. I
suppose it depends on what you are trying to achieve.

cheers, Alex.

--

Alexander C. Le Dain, PhD
ICON Technologies Pty Ltd
http://www.icon-tech.com.au

[Gorka Larrea]

What I want to do, is to format different test results
saved in different spreadsheet files into one Excel file,
put all the results in one workbook (different worksheets).
I've put all the data in a workbook, but I'd like to give
sheets a kind format, center data in cells, change fonts...
that's what I'm trying to achieve without success. Seems
like I've lost something... If you have any examples (in
LabVIEW 5.0.1f1 format) it would be great to have them.
Thanks for all

Gorka Larrea
glarrea_1@hotmail.com


* Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful

[Alex]

[posted and mailed]

glarrea_1@hotmail.com (Gorka Larrea) wrote in
<12ea1f1c.8985260d@usw-ex0109-070.remarq.com>:

>What I want to do, is to format different test results
>saved in different spreadsheet files into one Excel file,
>put all the results in one workbook (different worksheets).
>I've put all the data in a workbook, but I'd like to give
>sheets a kind format, center data in cells, change fonts...
>that's what I'm trying to achieve without success. Seems
>like I've lost something... If you have any examples (in
>LabVIEW 5.0.1f1 format) it would be great to have them.
>Thanks for all

XL-VIEW is also a solution. It has much more control over the formatting
side. Rather than re-invent the wheel perhaps just purc
hase a copy. They
have a demo download from their site. From memory they are:

http://members.aol.com/ELSSsales/

Nore: that the demo doesn't work on my machine for some unknown reason
which doesn't mean that the product is bad, but that it may be up to each
installation of Excel and that may be a problem for client machines.

cheers, Alex.

--

Alexander C. Le Dain, PhD
ICON Technologies Pty Ltd
http://www.icon-tech.com.au

[Gorka Larrea]

Alex,

It seems that I've no luck at all, the demo you talk me
about is for version 5.1 of LabVIEW, and I have version
5.0.1f1. The question is that as it is a demo version it
won't have any diagrams, and don't think I can have a 5.0
version of the demo.
Thanks anyway

Gorka Larrea
glarrea_1@hotmail.com


* Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful

[Reinis Kanders]

You can create a template with prepared formating, etc. Then if you open a
workbook with this templates file path a new file fill be created, fill it
with your data, do save as method, and then you should be all set.

Reinis Kanders

"Gorka Larrea" wrote in message
news:00fa3dc4.6da79dda@usw-ex0108-062.remarq.com...
> Easy Macro is good, but as long as I tried the demo a while
> ago, I realized that it was for LabVIEW 5.1 and I'm still
> running version 5.0.1f1, as the project I'm preparing is a
> single one with no more use of LabVIEW in the future, I
> can't even think of buying anything for this. If someone
> could give me some advice I'd be very happy.
> Thanks for all
>
> Gorka Larrea
> glarrea_1@hot
mail.com
>
>
> * Sent from AltaVista http://www.altavista.com Where you can also find
related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is
Beautiful




-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 80,000 Newsgroups - 16 Different Servers! =-----