This project has moved and is read-only. For the latest updates, please go here.

Best practice for using ClosedXML in an Excel AddIn?

Oct 14, 2015 at 10:36 PM
I am sure you folks are aware of the ambiguity between the assemblies:

Microsoft.Office.Interop.Excel

and

Microsoft.Office.Tools.Excel

My applications (AddIns) are becoming more and more complex. After winging it for years, I am afraid I need to take a more formal approach in order to stay away from this source of potential trouble.

I have casting all over and have code like this:
    Microsoft.Office.Interop.Excel.Range dstRange = worksheet.get_Range("B3");
    dstRange.Value2 = text;
which can be done in a nicer way with ClosedXML.
Oct 14, 2015 at 11:02 PM
I just discovered that my AddIns do not even use ClosedXML.

So the question becomes: How to use OpenXML inside AddIns?

TIA