Is there any way to just read the excel worksheet name?

[TomWang]

Hi

recently i just got this project need to read data from excel file, and after a few days of research i understand u can read and write to excel to  worksheet that the name or postion is known.

but is there any way to just read the excel worksheet name? As there excel format is not fixed and i need to search and open only the sheets i need.

I  try change it to string but dun seem to work.

not sure is this the right way... anyone?

[MikeS81]

Hi TomWang,

seet the attached picture, please. It shows how you can read all sheet names.

Mike

[TomWang]

That great help!!! Thanks a lot. I can save some sleep time with it


Message Edited by TomWang on 06-17-2008 04:39 AM

[TomWang]

Just one more question how did u got to the excel._worksheet with name?
my always gets excel.sheets with no option of Name... and i cant a way to change it...

I am still quite new to this...

[TomWang]

nvm i got it... Thx... Mike...




Message Edited by TomWang on 06-17-2008 05:20 AM

[shiness.tw]

Now I can read the sheet name, but Can I modify the sheet name??

[MikeS81]

Hi shiness.tw,
yes you can rename the sheet. The attached picture shows how.

Mike


Message Edited by MikeS81 on 07-05-2008 09:26 AM

[MWman101]

In the Unbenannt1.PNG (33 KB) diagram, Varient to Data function.  How do you coerce the 'Type constant to 'Excel,_Worksheet when drawing diagram?

[parthabe]

There is nothing to coerce actually.

First, create a constant ref for the prop node on the left-most. Then, del its wire & move it to the Variant to Data function & connect to it. Now, rt-click on the ref constant & choose Select ActiveX Class > Browse.. option. Select the Type Library as Microsoft Excel 11.0... & the Object as _Workbook.

Thats it, it ll automatically fetch you the Excel_Worksheet reference as the data.

[dgd.gomez]

hi, it is a little older the subject, but I would like to add a new question. you can get the name of the sheet that are active in excel? that is, if I change my excel sheet manually, you can get the selected sheet since LabView? Thanks.