[WD24] - Excel worksheet name

Hi All

I need to test the name of a worksheet tab in an Excel file. I use XLSOpen() to open the file and the help says I can use "LeafName" on an xlsDocument variable but I cant make it work.

If I use myXlsDocumentVariable..LeafName the syntax checker says the double dot is not recognized.

If I use myXlsDocumentVariable.LeafName the syntax checker is OK but it fails during runtime with "LeafName is not a valid column" error message.

How can I get the worksheet (leaf) name ?

Thanks

[UPDATE] - I found it - I need to use the property "WorksheetName" as per the Intellisense suggestion. The WD help file says "LeafName" but Intellisense says "WorksheetName". All good now. Thanks for reading



Edited 1 time(s). Last edit at 04/28/2020 10:48AM by JP.

Hi JP

I use this in Webdev

FOR i=1 TO xlsNbWorksheet(IDXLSFile)
xlsCurrentWorksheet(IDXLSFile, i)
ListAdd(combo_worksheet,IDXLSFile..WorksheetName)
END

Regards


Ericus Steyn

Thanks Ericus. I got the "WorkSheetName" property working.

Cheers!