Chart creation using Excel DNA

[anil sonawane]

Hi Team,

I want to draw charts using excel DNA but I don't want to use Interop excel to my add in.

Could you please tell me is it possible with excel DNA? 

Regards,

Anil

[Govert van Drimmelen]

Hi Anil,

For charting with Excel, it's best to use the COM object model in some way.

The C API has very limited support for charting, and not consistently across versions.

There are a numbers ways of doing the COM integration with your add-in:

* you can reference an interop assembly, possibly embedding in your assembly so you need not redistribute anything extra,

* you can use late binding, either from VB.NET using the 'Object' type and its late-binding support, or using the 'dynamic' type in C#,

* you can build your own wrappers based on reflection,

* you can use a version-independent wrapper library like NetOffice (https://netoffice.codeplex.com/)

What are your concerns with the Interop library?

Regards,

Govert