Delphi:
- WorkBook.WorkSheets[1].Copy(,WorkBook.WorkSheets[1]); // 把WorkSheets[1]複製到WorkSheets[1]之后
- WorkBook.WorkSheets[1].Copy(WorkBook.WorkSheets[1]); // 把WorkSheets[1]複製到WorkSheets[1]之前
C#:
object missing = Missing.Value;
- wbook1.Worksheets.Copy(missing, wbook2.Sheets["Sheet1"]);//在excel檔2的Sheet1之後插入所有excel檔1的Sheet
- wbook1.Worksheets.Copy(wbook2.Sheets["Sheet1"], missing);//在excel檔2的Sheet1之前插入所有excel檔1的Sheet