Does anyone have .Net Excel IO component benchmarks?

Question!

I'm needing to access Excel workbooks from .Net. I know all about the different ways of doing it (I've written them up in a blog post), and I know that using a native .Net component is going to be the fastest. But the question is, which of the components wins? Has anybody benchmarked them? I've been using Syncfusion XlsIO, but that's very slow for some key operations (like deleting rows in a workbook containing thousands of Named ranges).



Answers

I've had good results with EPPlus in the past, and I've found it to be very reliable and fast. Unlike SyncFusion, it doesn't require a singleton object to prevent concurrency issues, and it is open source.



I haven't done any proper benchmarks, but I tried out several other components,and found that SpreadsheetGear was considerably faster than XlsIO which I was using before. I've written up some of my findings in this post



This video can help you solving your question :)
By: admin