Solved

embed a .NET chart in MS Excel

Posted on 2015-01-20
2
97 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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 article surveys and compares options for encoding and decoding base64 data.  It includes source code in C++ as well as examples of how to use standard Windows API functions for these tasks. We'll look at the algorithms — how encoding and decodi…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
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…

867 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

18 Experts available now in Live!

Get 1:1 Help Now