Solved

embed a .NET chart in MS Excel

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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

This article shows how to make a Windows 7 gadget that extends its U/I with a flyout panel -- a window that pops out next to the gadget.  The example gadget shows several additional techniques:  How to automatically resize a gadget or flyout panel t…
This article describes how to add a user-defined command button to the Windows 7 Explorer toolbar.  In the previous article (http://www.experts-exchange.com/A_2172.html), we saw how to put the Delete button back there where it belongs.  "Delete" is …
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…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

792 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