Merge 2 books

Aspose.Cells Product Family
1

Dear Team Aspose:


how to merge 2 or more Excel workbooks into one, the sheets can contain data, graphic objects and charts,
I am waiting for your comments,

king regards,

Marcelo Parraguez A.
2

Hi,

Thank you for considering Aspose.

You may use Workbook.Combine API to combine / merge multiple excel workbooks into one workbook. Please see the following documentation article for further details and sample code.

http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/combine-multiple-workbooks-into-a-single-workbook.html

Thank You & Best Regards,

3

Many Thanks!!


King Regards,

Marcelo Parraguez A.
4

@mparrag1

See our new/updated document on the feature for your reference:
Combine workbooks

Also, we recommend to upgrade to newer Aspose.Cells for .NET, which has many useful features and other enhancements. The following sample code exhibits on how to combine two workbooks into one file:
e.g.
Sample code:

Workbook SourceBook1 = new Workbook("Book1.xlsx");

// Define the second source book.
// Open the second excel file.
Workbook SourceBook2 = new Workbook("Book2.xlsx");

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

// Save the target book file.
SourceBook1.Save("combinedBook.xlsx");

You may download our latest versions of Aspose.Cells APIs here:
Aspose.Cells for .NET (Latest Version)

Moreover, we recommend you to download and browse our up-to-date demos for your complete reference.