使用列表中的名称重命名Excel工作表

由妖小精发布于 2020-05-09 05:41:31

我正在尝试在Excel工作簿中重命名工作表。谁能告诉我我缺少或做错了什么吗？

        //Execute Excel
        Excel.Application ex = new Excel.ApplicationClass();
        ex.Visible = true;
        ex.DisplayAlerts = false;
        //Create workbook
        Excel.Workbook wb = ex.Workbooks.Add();
        //Create sheets with names
        List<string> names = new List<string> {"03 SHEET 03","02 SHEET 02","01 SHEET 01"};
        foreach (string name in names) 
        {
            wb.Worksheets.Add().Name = name;
        }

猫o喵

2020-05-09 05:41:31

Your code example works with little adjustment. I just changed Excel initialization from new Excel.ApplicationClass() to new Excel.Application(). Here is my full code:

static void Main()
{
    Microsoft.Office.Interop.Excel.Application ex = new Microsoft.Office.Interop.Excel.Application();
    ex.Visible = true;
    ex.DisplayAlerts = false;
    Microsoft.Office.Interop.Excel.Workbook wb = ex.Workbooks.Add();
    var names = new List<string> { "03 SHEET 03", "02 SHEET 02", "01 SHEET 01" };

    foreach (string name in names)
    {
        wb.Worksheets.Add().Name = name;
    }
}

Of course, I had to add the reference to Microsoft.Office.Interop.Excel library. If you have any other issues, please provide more details about the errors (compile, runtime exception).

妖小精

这家伙很懒，什么都没留下

积分
0
话题
0
评论
3205
注册排名
2142