110,566
社区成员
发帖
与我相关
我的任务
分享
workbook = xlsApp.Workbooks.Open(excelPath, oMissing, oMissing, oMissing,
oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing,
oMissing, oMissing, oMissing, oMissing);
Worksheet mysheet;
for (int i = 1; i <= workbook.Sheets.Count ; i++)
{
if (((Worksheet)workbook.Sheets[i]).Name == "3-10$")
{
((Worksheet)workbook.Sheets[i]).Delete();//操作执行了,可是工作表确没有删除
break;
}
}
mysheet = (Worksheet)workbook.Worksheets.Add(oMissing, oMissing, oMissing, oMissing);
mysheet.Name = sheetName;//运行到这里 就报错了,说不能重复命名