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(); }