ExcelDnaUtil vs Interop.Excel
c#, excel, excel-dna, vsto
Solution
If performance matters then avoid VSTO-Interop. If you need to target multiple Excel versions avoid VSTO-Interop. If you think you might want UDFs in the future avoid VSTO-Interop.
Otherwise VSTO is OK.
As well as Excel-DNA you should also look at Addin-Express, which also does not suffer from the VSTO shortcomings.
Problem
I am currently comparing Excel-DNA vs VSTO and Interop. I am interested in creating an Add-in for Excel using C#. I don't need to create UDF's, but only interact with Excel, ex: read cells, write cells, create sheets, etc. Which solution would be better for this: Excel-DNA or VSTO? Thank you.