What you could do in this scenario is to open your excel file, load its active worksheet using the RadSpreadProcessing library, use RadGridView's ExportToWorkbook
method and merge the two files using RadSpreadProcessing
functionality, similarly to:
Workbook currentWorkbook = gridView.ExportToWorkbook();
var range = currentWorkbook.ActiveWorksheet.UsedCellRange;
var fragment = currentWorkbook.ActiveWorksheet.Cells[range].Copy();
PasteOptions valuesAndFormatting =
worksheet.Cells[worksheet.UsedCellRange.RowCount + 1, 0].Paste(fragment, valuesAndFormatting);
Additionally, the issue you're referring to regarding the misaligned column groups was fixed with the
internal build. Could you please try updating to the latest release of the controls (R3 2016
) and let me know if it solves this?
I hope you find this helpful. Do let me know if you need any further assistance on the matter.
Telerik by Progress
Do you need help with upgrading your WPF project? Try the Telerik API Analyzer
and share your thoughts!