Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I get all worksheets' names of the spreadsheet?
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! -- marxi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I get all worksheets' names of the spreadsheet?
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 On 5 Feb, 07:45, marxi wrote: 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! -- marxi |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I get all worksheets' names of the spreadsheet?
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. -- marxi "RichardSchollar" wrote: 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 On 5 Feb, 07:45, marxi wrote: 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! -- marxi |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I get all worksheets' names of the spreadsheet?
In excel's vba:
Dim ws as worksheet marxi wrote: 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. -- marxi "RichardSchollar" wrote: 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 On 5 Feb, 07:45, marxi wrote: 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! -- marxi -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I get all worksheets' names of the spreadsheet?
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. -- marxi "Dave Peterson" wrote: In excel's vba: Dim ws as worksheet marxi wrote: 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. -- marxi "RichardSchollar" wrote: 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 On 5 Feb, 07:45, marxi wrote: 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! -- marxi -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I get all worksheets' names of the spreadsheet?
Maybe someone will jump in with the solution.
marxi wrote: 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. -- marxi "Dave Peterson" wrote: In excel's vba: Dim ws as worksheet marxi wrote: 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. -- marxi "RichardSchollar" wrote: 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 On 5 Feb, 07:45, marxi wrote: 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! -- marxi -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
names in different worksheets | Excel Worksheet Functions | |||
How can I get worksheets' names in spreadsheet | Excel Worksheet Functions | |||
Excel Spreadsheet from Access. List of names changes as names are | Excel Discussion (Misc queries) | |||
Worksheets Names | Excel Programming | |||
Ok i have a spreadsheet with names | Excel Discussion (Misc queries) |