[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

embed a .NET chart in MS Excel

Posted on 2015-01-20
2
Medium Priority
?
114 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying 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

With most software applications trying to cater to multiple user needs nowadays, the focus is to make them as configurable as possible. For e.g., when creating Silverlight applications which will connect to WCF services, the service end point usuall…
A theme is a collection of property settings that allow you to define the look of pages and controls, and then apply the look consistently across pages in an application. Themes can be made up of a set of elements: skins, style sheets, images, and o…
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…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…

650 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