Is there a function or way to combine two or more separate instances of a Workbook into a single Workbook?
The Workbook class doesn't currently have a method for merging workbooks into a single one. Nor does it allow for Worksheet instances to be added directly to the Workbook.Worksheets collection. So really the only way to merge workbooks would be to iterate over the cells in one workbook and set their values based on the other workbook cells.
I recommend that you submit this as a product idea for the Infragisics Excel Library as it is a pretty neat idea. You can do this here: http://ideas.infragistics.com. If you post this idea, make sure to include a link to this forum thread so our product management team can look back on it if necessary.
I have created the following suggestion:
Thanks for adding this!