?
Solved

embed a .NET chart in MS Excel

Posted on 2015-01-20
2
Medium Priority
?
116 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 2000 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

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

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

In this article, I will show how to use the Ribbon IDs Tool Window to assign the built-in Office icons to a ribbon button.  This tool will help us to find the OfficeImageId that corresponds to our desired built-in Office icon. The tool is part of…
zlib is a free compression library (a DLL) on which the popular gzip utility is built.  In this article, we'll see how to use the zlib functions to compress and decompress data in memory; that is, without needing to use a temporary file.  We'll be c…
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 shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…

864 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