public Worksheet CopySheetAndDeleteOther(ExcelSheet S)
{
Worksheet ws = (Worksheet)workbook.Sheets[1];
S.WorkSheet.Copy(ws);
//int trytimes = 0;
//while (workbook.Sheets.Count >2 && trytimes++<10)
string sheetname = "";
foreach (Worksheet w in workbook.Worksheets)
{
sheetname += w.Name + "\t";
}
sheetname += "========\r\n";
for (int i = 1; i < 4; i++)
{
Excel.Worksheet w = workbook.Sheets["Sheet" + i];
sheetname += w.Name + "\t";
w.Delete();
}
ws = workbook.Worksheets[1];
ws.Name = S.Name;
return(ws);
}
//删除掉某个表格
public void delTheSheet(int sheetIndex)
{
Worksheet sheet = (Worksheet)WBook.Sheets[sheetIndex];
sheet.Delete();
}
