I am currently comparing Excel-DNA vs VSTO and Interop. I am interested in creating an add-in for Excel using C #. I do not need to create UDF, but only interact with Excel, for example: read cells, write cells, create sheets, etc.
Which solution would be better for this: Excel-DNA or VSTO?
Thank.
If performance matters, then avoid VSTO-Interop.If you need to target multiple versions of Excel, avoid VSTO-Interop.If you think you want UDF to avoid VSTO-Interop in the future.
Otherwise, VSTO is fine.
Excel-DNA, Addin-Express, VSTO.
VSTO , UDF.