concatenating multiple workbooks

[rose]

Hello,
I am a user of the Spire .XLS. And I am interested in the Spire .XLS when I use it.
Now I have a question about it. That is whether I can concatenate multiple workbooks in C# using Spire .XLS.
Can you show me any method?

thanks

[iceblue support]

If you want to do so, you can follow the codes below:
//Creating source workbook
Workbook workbook = new Workbook();
//Load workbook from disk.
workbook.LoadFromXml(@"..\..\test1.xls");

//Creating destination workbook
Workbook workbookDest = new Workbook();
//Load workbook from disk.
workbookDest.LoadFromXml(@"..\..\test2.xls");

//Copy worksheets from source to destination
workbookDest.Worksheets.AddCopy(workbook.Worksheets);

//Save workbook to disk file.
workbookDest.SaveToFile("Sample.xlsx",ExcelVersion.Version2007);

//View excel file.
ExcelDocViewer(workbookDest.FileName);