Solved

embed a .NET chart in MS Excel

Posted on 2015-01-20
2
94 Views
Last Modified: 2015-01-22
I am working with MS Excel and the graphing engine is not just good enough. I would like to use another graphing engine, eg. Infragistics or telerik, inside Excel. So instead of classical MS Excel 2010 graph I would like to have a .NET one, that can be manipulated from inside MS Excel.
0
Comment
Question by:Frans_Truyens
2 Comments
 
LVL 40

Accepted Solution

by:
Jacques Bourgeois (James Burger) earned 500 total points
ID: 40563299
Excel is able to embed COM objects, but has no direct knowledge of .NET. Although you can call some .NET dlls from VBA in Excel, you cannot embed .NET control in the worksheet.

You can do it with Windows.Forms controls in you create an Excel add-in project in Visual Studio as introduced in Programming Excel Workbooks by Using Host Items and Host Controls. I am not sure however that it would work with a 3rd party control.
0
 

Author Closing Comment

by:Frans_Truyens
ID: 40564003
Thanks!
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

This article describes how to programmatically preset the "Pages per Sheet" option that's available with most printer drivers.   This setting lets you do "n-Up" printing, where two, four, or more pages are printed on each sheet of paper. If your …
If you have ever found yourself doing a repetitive action with the mouse and keyboard, and if you have even a little programming experience, there is a good chance that you can use a text editor to whip together a sort of macro to automate the proce…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
This video discusses moving either the default database or any database to a new volume.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now