彩票走势图

在对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")

代码运行后效果图如下：