被迫从NPOI到microsoft interop,我不得不执行一项在工作簿中查找特定工作表的任务,然后遍历它的每一行。
在NPOI中,它将是简单的workbook.GetSheet(sheetName);
。在microsoft互操作中,与此等效的是什么?
发布于 2011-11-10 00:06:36
使用workbook.Sheets[sheetName];
完整的工作示例:
using Microsoft.Office.Interop.Excel;
class Program
{
static void Main(string[] args)
{
var excelApplication = new Application();
excelApplication.Visible = true;
excelApplication.SheetsInNewWorkbook = 3;
var workbook = excelApplication.Workbooks.Add();
var worksheet = workbook.Sheets["Sheet2"]; //<--- desired method
worksheet.Activate();
}
}
https://stackoverflow.com/questions/8067115
复制相似问题