Merging large Excel files into 1 most efficiently

[David Myers]

I have multiple large (50k plus rows) Excel workbooks that I need to merge together based on common GUID keys. What are best approaches to optimize this? I am currently reading each file into memory as an arraylist and then looping through each array list to find matching merge records.

[Shamini Kiruba Sobers]

Hi David, 

 

Greetings from Syncfusion support. 

 

You can copy worksheets from multiple workbooks and merge them together into a single workbook with the help of AddCopy operation. Kindly look into the following KB links to achieve your requirement using AddCopy operation. 

 

Help links: 

https://www.syncfusion.com/kb/1935/copy-excel-worksheet-to-another-workbook-in-c-vb-net 

https://www.syncfusion.com/kb/1866/how-to-merge-several-excel-files-to-single-file 

 

You can export data from Excel workbooks to collection objects and then import data from collection objects to an Excel workbook with the help of the below UG links. 

 

UG links: 

https://help.syncfusion.com/file-formats/xlsio/working-with-data#exporting-from-worksheet-to-collection-objects 

https://help.syncfusion.com/file-formats/xlsio/working-with-data#import-data-from-collection-objects 

 

Kindly let us know more details about the issue you are facing, if the above suggestions didn’t help. Also, please share the code that you are using currently along with the input Excel files to investigate further and provide prompt solution at the earliest. 

 

Regards, 

Shamini