c# 控制Excel 复制Sheet 我已经指定sheet 为什么结果是Excel中所有的Sheet都有副本?

Question

因为需要开始研究c#对于Excel的控制,在复制Sheet后,为什么所有的Sheet都有副本.下面是我的代码
:
string   strPath="D:\\test.xls"; 
object   oMissing=System.Reflection.Missing.Value;  
Excel.Application ExTest  = new Excel.Application () ;
Excel.Workbook book=ExTest.Workbooks.Open(strPath,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing);
Excel.Worksheet sheet=(Excel.Worksheet)book.Worksheets[1];
book.Worksheets.Copy(Type.Missing,sheet);原来Excel中有[模版]和[bb]2个sheet,运行程序后Excel中变成了[模版],[模版(2)],[bb(2)],[bb]4个sheet.
请大家帮我解决下 谢谢~

Answer 1

ok 谢谢大家能看 我已经解决了.
string   strPath="D:\\test.xls";  
object   oMissing=System.Reflection.Missing.Value;   
Excel.Application ExTest  = new Excel.Application () ; 
Excel.Workbook book=ExTest.Workbooks.Open(strPath,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing); 
Excel.Worksheet sheet=(Excel.Worksheet)book.Worksheets[1]; 
book.Worksheets.Copy(Type.Missing,sheet); //这里错了 应该指定要复制的Sheet.正确的是:sheet.Copy(Type.Missing,book.Sheets[2]);
:sheet:所要复制的sheet,从上面语句中获取.
book.Sheets[2]:所要复制到第几个sheet.

Answer 2

多谢楼主 终于找到可以复制sheet了