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.

//Merging worksheets
destinationWorkbook.Worksheets.AddCopy(sourceWorkbook.Worksheets);

'Merging worksheets.
destinationWorkbook.Worksheets.AddCopy(sourceWorkbook.Worksheets)

Here is the sample for your reference:

Did you find this information helpful?

Yes

Comments (0)