Fast third party library to merge excel files (.Net)?

Question

Hi,

i am looking for a 3rd party utility pack sort of library for .Net to handle excel merging with formating, formulas, charts and etc. which does its job well and if possible fast.

Answer 1

I assume you already know how to do it manually but just incase it can be done without a third party software as this article details...

http://www.ehow.com/how_13023_merge-workbooks-excel.html

You can also use the following to handle bulk merging for you

http://www.essexredevelopment.com/

Answer 2

SpreadsheetGear for .NET can do it. You should try it with your own workbooks to know whether it's fast in your case, but you can see quotes from some SpreadsheetGear customers regarding performance on the right hand side of this page.

You can see the live "Excel Workbook Consolidation" sample with C# and VB.NET source on our Excel Reporting samples page and download the free trial here.

Disclaimer: I own SpreadsheetGear LLC