在對Excel的操作中，我們經常用到工作簿合并，那么，Aspose.Cells是如何實現這一功能的呢？下面，我們就舉一個實例來為大家講解Aspose.Cells是如何將兩個包含圖像和圖表的工作簿合并為一個的。

合并前：

工作簿1：PictureTest.xls

工作簿2： ChartTest.xls (2 worksheet)

我們將這兩個工作簿合并為一個：Combined.xls，代碼如下：

[C#]

 //Define the first source
//Open the first excel file.
Workbook SourceBook1 = new Workbook("c:\\excels\\ChartTest.xls");

//Define the second source book.
//Open the second excel file.
Workbook SourceBook2 = new Workbook("C:\\excels\\PictureTest.xls");

//Combining the two workbooks
SourceBook1.Combine(SourceBook2);

//Save the target book file.
SourceBook1.Save("c:\\excels\\combined.xls");
 
[VB]

 'Define the first source book.
'Open the first excel file.
 Dim SourceBook1 As New Workbook("c:\excels\ChartTest.xls")

 'Define the second source book.
 'Open the second excel file.
 Dim SourceBook2 As New Workbook("C:\excels\PictureTest.xls";)

 'Combining the two workbooks
 SourceBook1.Combine(SourceBook2)

 'Save the target book file.
 SourceBook1.Save("c:\excels\combined.xls")

代碼運行后效果圖如下：