Category / Section
How to merge several Excel files to single file?
1 min read
Use the following code snippets to merge several Excel files to single Excel file.
C#
//Merging worksheets destinationWorkbook.Worksheets.AddCopy(sourceWorkbook.Worksheets);
VB
'Merging worksheets. destinationWorkbook.Worksheets.AddCopy(sourceWorkbook.Worksheets)
Here is the sample for your reference:
http://www.syncfusion.com/downloads/support/directtrac/general/Merging203273142.zip