I am looking for any inbuilt functionality in GemBox that allows merging two Excel files. Specifically, I need a functionality where I can provide two Excel files as input, and it generates a single Excel file by stacking the content of the two files in one sheet, one below the other.
Hi Saurabh,
Please check the second example on this page, it shows how to copy cells:
So what you’ll need to do is get the cell range from the source sheet (ExcelWorksheet.GetUsedCellRange(true)) and copy it to destination sheet starting on some desired location (CellRange.CopyTo()).
I hope this helps.
Regards,
Mario