LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Read back sheet names in excel workbook

Solved!
Go to solution

I'm trying to build a vi to organize my data in Excel workbooks.

There are available ActiveX controls to communicate with MS Office, but I couldn't find any usable help and detailed explanation of controls, properties, arguments, commands etc.

For example, I want to do simple task- to open a workbook and read back the list of worksheets names.

 

Generally- where I can find  a help for the activeX controls? Are they part of the MSO excel activeX library (if so, where I can find info), or this is a library build by NI?

 

Or  I must browse and guess all the properties blindly until find some dodgy way>

0 Kudos
Message 1 of 12
(11,494 Views)
Look here for more. Smiley Happy
- Partha ( CLD until Oct 2027 🙂 )
0 Kudos
Message 2 of 12
(11,484 Views)

Here is an old stuff I made for a guy who asked a question about ActiveX and Excel (see attached screenshot). I've added a property node to show you how you can retrieve a sheet name.

 

Generally, you can have a look at some examples included when you install LabVIEW : you can search an example by name (you just need to type "ActiveX" or "Excel"). The problem with ActiveX is that it's not always well documented.

0 Kudos
Message 3 of 12
(11,483 Views)

Thanks Krzone, this is exactly the answer.

 

Also, thanks to parthabe, the link to the excel board is great help.

 

Appears the answers are more in VB and Excel forums, than in LV. Still I must find out  how to translate VB to LV... looks simple but...

 

0 Kudos
Message 4 of 12
(11,474 Views)

Dimo wrote:

 

Appears the answers are more in VB and Excel forums, than in LV.


I m afraid, there is no Excel forum/board within NI site, it is actually a Excel (repository) thread floated in the Special Interest Board Breakpoint.

- Partha ( CLD until Oct 2027 🙂 )
0 Kudos
Message 5 of 12
(11,472 Views)

Hi Dimo

 

Once you move into ActiveX and Excel territory MSDN is a good resource for information on Excel specific methods, arguments and so on. The examples are in C#, VB or C++, but you get an idea on how to use calls in the enviroment. Hope this helps.

 

Best Regards

 

David

NISW

0 Kudos
Message 6 of 12
(11,455 Views)
Solution
Accepted by