Obtaining Excel worksheet reference by worksheet name via C

Question

I'm currently obtaining a handle for an Excel worksheet by using the below C# code:

Excel.Worksheet worksheet = (Excel.Worksheet)sheets.get_Item(15);
//Get the worksheet "SubSignOff" number

Is there any way that I can obtain the same by using the worksheet name "SubSignOff"?

Answer 1

Instead of using Excel.Workbook.Sheets collection, it's easier to access Excel.Workbook.Worksheet collection, that way you can utilize early binding.

I hope this helps you.