I need a way to return the sheet names for all sheets in excell

[mda711]

how can I get all of the sheet names from excel using active x

[JellyBeans]

Use "Write Table To XL.vi" example that ships with LabVIEW as starting point.

From Application>>Workbook get hold of Worksheet object and iterate through it, reading its item names.

A Rafiq

[Michael_Munroe]

Actually you will need Application->Workbook->Sheets and iterate through it. The plural sheets is a collection of the sheet objects.

This is the equivalent VBA that you will need:

With ActiveWorkbook
For i = 1 To .Sheets.Count
strName(i) = .Sheets(i).Name
Next
End With

Michael Munroe
www.abcdef.biz

[Thierry_Vorms]

Hello,

LabView is a graphical langage ....

How can I write thze loop to find all sheets name in LabView ?

Many thanks for your help

[K C]

Hi,

In a VI read Excel I have I added a bit for pulling out the names of the Excel sheet names.

It's a bit messy but it works so you can use this part.

Message Edited by K C on 11-08-2006 12:53 PM

[kkronline]

please send the VI which can be used for LV 7.1

thanks in advance

karthik

[K C]

Hi,

Here it is. The merge errors VI is not available in 7.1

[tonitpp]

Hi,

Could you attach this example in LV 7 Express please? I want to write the results of my database tables to the different sheets of the same Excel workbook.

Thanks in advance.

[Joe_H]

Have you had a look at the Excel board. There are a lot of VI's on there that will help you when working with Excel.

For more information and some sample VI's and tool kits, you can go to the excel board

[Ziccozzis]

Mmmmm...

KC, i would like there were some explanation in the VI's you attached.

I'm new and I don't understand all the process

I almost forgot, sorry about my english, jsjsjsjsjsjsjs