我正在尝试重命名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;
}
您的代码示例只需少量调整即可工作。我刚刚将Excel初始化从new Excel.ApplicationClass()
更改为new Excel.Application()
。这是我的完整代码:
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;
}
}
当然,我不得不添加对Microsoft.Office.Interop.Excel
库的引用。如果您有任何其他问题,请提供有关错误(编译、运行时异常(的更多详细信息。