Displaying Excel chart in C# application

[JT]

Hi,

I've read (and tried) the article "How To Automate Microsoft Excel from
Microsoft Visual C# .NET" (available at
http://support.microsoft.com/default.aspx?kbid=302084). This opens up Excel,
fills in a spreadsheet with numbers, and creates a chart in the spreadsheet
from the data.

Is there a way to do that, but insted of showing the chart in Excel, never
have the Excel window show up and just show the excel chart within my
application?

Thanks
JT

 

[Jon Peltier]

JT -

I haven't caught the .Net craze yet, and until my musician daughter
recently corrected me, I thought C# was pronounced "cee-pound". But here
are a couple thoughts anyway.

I imagine you could insert an OLE object in your app that contained an
Excel workbook object, with the chart showing in front of the rest of
the workbook. This is basically what happens when you paste an Excel
chart into another Office application.

Alternative approaches include using the OWC chart in your app, or
another of the numerous chart controls.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______