LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How to generate the handle(Refnum) of excel

Solved!
Go to solution

Hi Sir, 

 

I am reviewing the labview code, not sure how to generate or say where to get this excel handle.

As well as other kind of handles for third-part tools.

Thanks.

 

Brzhou_0-1679987457408.png

 

0 Kudos
Message 1 of 6
(485 Views)
Solution
Accepted by topic author Brzhou

There are several alternatives. Maybe they're better.

One alternative is ActiveX. Another is to use built in VIs for access to Excel, as far as I know part of the Report Generation Toolkit.

The best way is to use royalty free or paid third party tools like CLAUDIE or what else there is. More convenient. 

0 Kudos
Message 2 of 6
(476 Views)
Solution
Accepted by rolfk

Hi Sir,

 

This way, right ?

By the way, how to add more in that list ?

Thanks.

 

 

Brzhou_0-1680004972977.png

 

0 Kudos
Message 3 of 6
(442 Views)

@Brzhou wrote:

Hi Sir,

 

This way, right ?

By the way, how to add more in that list ?

 


Do you see the Browse.... line at the end? Have you tried that?

 

The menu only shows the ActiveX classes that have already been loaded. (And once an ActiveX Automation Server has been loaded it stays loaded until you quit LabVIEW).

Rolf Kalbermatter
My Blog
0 Kudos
Message 4 of 6
(431 Views)

Yes, i saw that:

 

Brzhou_0-1680013024329.png

Also from the tool function, i can import Active X:

Brzhou_1-1680013069083.png

 

But what is the relationship ? need to import first ?

Thanks.

 

0 Kudos
Message 5 of 6
(409 Views)

The first is simply to associate a specific refnum to an ActiveX class.

 

The second simply creates such a refnum on the fly and adds it to the menu palette. It's just a convenience function.

Rolf Kalbermatter
My Blog
Message 6 of 6
(404 Views)