Search code examples
c#excelvstoexcel-dna

ExcelDnaUtil vs Interop.Excel

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.

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.