excel charts using asp.net

[Fred]

Is it possible to generate a chart using the excel 2007 engine for a web
page? (output in jpg)...
If not what 3rd party solution would you recommend for this purpose

Thanks,
Fred

 

[John Timney \(MVP\)]

Theres a gazzillion approaches - from actually using excel via interop to
creating simple bar charts with stretched gifs or dedicated components.
Millions of results via google but here is one to get you started
http://aspnet.4guysfromrolla.com/articles/080603-1.aspx

Regards

John Timney (MVP)
http://www.johntimney.com
http://www.johntimney.com/blog

 

[Mark Rae [MVP]]

Is it possible to generate a chart using the excel 2007 engine for a web
page? (output in jpg)...

Not using the Excel engine directly - server-side Office Automation doesn't
work, and isn't even supported by Microsoft:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257757#kb2

However, does it actually *have* to be Excel? You certainly don't *need*
Excel just to generate a chart for an ASPX page...

But, if it does have to be Excel, you might consider using the OpenXML
format for Office 2007:
http://msdn2.microsoft.com/En-US/library/aa338205.aspx

This has one immediate advantage - it's free! However, it is most definitely
*not* for the faint-hearted! Even the most experienced XML coder will find
this a bit of a challenge...

If not what 3rd party solution would you recommend for this purpose

Well, if it *has* to be Excel, this is the industry-standard:
http://www.aspose.com/Products/Aspose.Cells/Default.aspx

If not, there are literally dozens (if not hundreds!) of 3rd-party charting
tools for (ASP).NET - this is the one I use:
http://www.advsofteng.com/cdnet.html

 

[Guest]

Hello,

As john points out a good solution is to use Office Web Components, Here
you have an extra link about it:

http://www.eggheadcafe.com/articles/20021223.asp

It makes exactly what you want, and if you work a bit with XSL and
DataSets you can automate most of the process of creating charts.

One thing to take into consideration is that OWC in 2007 has changed, not
sure if even has the same name.

Good luck
Braulio


/// ------------------------------
/// Braulio Diez
///
/// http://www.tipsdotnet.com
/// ------------------------------

 

[Mark Rae [MVP]]

As john points out a good solution is to use Office Web Components, Here
you have an extra link about it:

http://www.eggheadcafe.com/articles/20021223.asp

Office Web Components have been discontinued:
http://blogs.msdn.com/excel/archive/2006/07/17/668544.aspx

One thing to take into consideration is that OWC in 2007 has changed,
not
sure if even has the same name.

See above...