Previous topicNext topic
Help > 开发指南 > Excel > API > 示例 > Workbook >
如何：将多个工作簿合并到一个文档中

使用以下方法之一将多个工作簿中的数据合并到单个文档中。


将工作簿复制到其他文档

Vb.Net
'创建一个Workbook工作簿对象.
Dim workbook1 As New DevExpress.Spreadsheet.Workbook()
workbook1.LoadDocument("D:\Document.xlsx", DevExpress.Spreadsheet.DocumentFormat.Xlsx)

'创建并加载第二个工作簿.
Dim book2 As New DevExpress.Spreadsheet.Workbook()
book2.LoadDocument("D:\Document2.xlsx", DevExpress.Spreadsheet.DocumentFormat.Xlsx)

'将工作簿1中的所有工作表都拷贝到工作簿2中去
book2.Append(workbook1)

C#
// 创建一个Workbook工作簿对象.
DevExpress.Spreadsheet.Workbook workbook1 = new DevExpress.Spreadsheet.Workbook();
workbook1.LoadDocument(@"D:\Document.xlsx", DevExpress.Spreadsheet.DocumentFormat.Xlsx);

// 创建并加载第二个工作簿.
DevExpress.Spreadsheet.Workbook book2 = new DevExpress.Spreadsheet.Workbook();
book2.LoadDocument(@"D:\Document2.xlsx", DevExpress.Spreadsheet.DocumentFormat.Xlsx);

// 将工作簿1中的所有工作表都拷贝到工作簿2中去
book2.Append(workbook1);

将工作簿合并到新文档中

Vb.Net
'创建一个Workbook工作簿对象.
Dim workbook1 As New DevExpress.Spreadsheet.Workbook()
workbook1.LoadDocument("D:\Document.xlsx", DevExpress.Spreadsheet.DocumentFormat.Xlsx)

'创建并加载第二个工作簿.
Dim book2 As New DevExpress.Spreadsheet.Workbook()
book2.LoadDocument("D:\Document2.xlsx", DevExpress.Spreadsheet.DocumentFormat.Xlsx)

'将工作簿1和工作簿2中所有的工作表都合并到一个新的工作簿中去。
Dim result As DevExpress.Spreadsheet.Workbook = Workbook.Merge(workbook1, book2)

C#
// 创建一个Workbook工作簿对象.
DevExpress.Spreadsheet.Workbook workbook1 = new DevExpress.Spreadsheet.Workbook();
workbook1.LoadDocument(@"D:\Document.xlsx", DevExpress.Spreadsheet.DocumentFormat.Xlsx);

// 创建并加载第二个工作簿.
DevExpress.Spreadsheet.Workbook book2 = new DevExpress.Spreadsheet.Workbook();
book2.LoadDocument(@"D:\Document2.xlsx", DevExpress.Spreadsheet.DocumentFormat.Xlsx);

// 将工作簿1和工作簿2中所有的工作表都合并到一个新的工作簿中去。
DevExpress.Spreadsheet.Workbook result = Workbook.Merge(workbook1, book2);