通过工作表名称通过C＃获取Excel工作表参考 [英] Obtaining Excel worksheet reference by worksheet name via C#

问题描述

我正在使用以下C＃代码获取Excel工作表的句柄：

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

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

有没有办法可以获得使用工作表名称SubSignOff？

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

推荐答案

使用 Excel.Workbook.Sheets 集合，更容易访问

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

在您的情况下，可能看起来像以下内容：

In your case, it could look something like the following:

Excel.Application excelApp = new Excel.Application();
excelApp.Visible = true;

Excel.Workbook workbook = excelApp.Workbooks.Open("C:\MyWorkbook.xls",
    Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, 
    Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, 
    Type.Missing, Type.Missing, Type.Missing, Type.Missing);

// The key line:
Excel.Worksheet worksheet = (Excel.Worksheet)workbook.Worksheets["SubSignOff"];

希望这有帮助...

这篇关于通过工作表名称通过C＃获取Excel工作表参考的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！