How can I get all worksheets' names of the spreadsheet?

[Guest]

As you know, a excel spreadsheet workbook can contains some worksheets and
each worksheet has its names, my problem is how to get these names. Who can
Help me ?
Any help will be very very appreciated!

 

[RichardSchollar]

Hi Marxi

Sub Worksheet_Names()
For Each ws In ThisWorkbook.Worksheets
Debug.Print ws.Name
Next ws
End Sub

will print the worksheet names to the Immediate Window. If you want
to print them to a worksheet itself, then maybe:

Sub Worksheet_Names()
For i = 1 to ThisWorkbook.Worksheets.Count
Cells(i,1).Value = ws.Name
Next i
End Sub

Hope this helps!

Richard

 

[Guest]

first and foremost, thank you for your advise!

The spreadsheet I said is a kind of COM for Csharp.NET.
It can drog on the winform to work for users as excel.
my problem is how to get the name of each worksheet using C# language.
I do not know the type of "ws" which mentioned in your answer!
Thanks again.

 

[Dave Peterson]

In excel's vba:
Dim ws as worksheet

first and foremost, thank you for your advise!

The spreadsheet I said is a kind of COM for Csharp.NET.
It can drog on the winform to work for users as excel.
my problem is how to get the name of each worksheet using C# language.
I do not know the type of "ws" which mentioned in your answer!
Thanks again.

 

[Guest]

C#can not use excel's vba and owc spreedsheet can not excute vba code.
I should use c# to solve this problem.
for example:
axSpreadsheet1.sheets.get_Names().ToString();
but "sheets" does not have the get_Names() method.

 

[Dave Peterson]

Maybe someone will jump in with the solution.

C#can not use excel's vba and owc spreedsheet can not excute vba code.
I should use c# to solve this problem.
for example:
axSpreadsheet1.sheets.get_Names().ToString();
but "sheets" does not have the get_Names() method.