C＃检查excel文件的WorkSheet名称并将其重命名

Question

我需要编写一个基本上应该以excel文件作为输入的C＃代码，并检查excel文件是否包含特定工作表或选项卡，如果是，请重命名该选项卡与另一个名字。该程序应该支持.net 3.5和excel 2007.请给我一些例子。提前致谢。

Answer 1

Full length code From one of the stack over posts

Answer 2

我对所有与Excel相关的代码都使用EPPlus。

Answer 3

Application excel = new Application(); 
Workbook wb = excel.Workbooks.Open(path, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value); 

    string lookFor="TabName1"; 

    foreach (Microsoft.Off.Interop.Excel.Worksheet w in wb.Worksheets) 
    { 
     if (w.Name == lookFor) 
     //match exists rename 
     w.Name = lookFor + "_renamed"; 
    }