excel charts using asp.net

  • Thread starter Thread starter Fred
  • Start date Start date
F

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
 
Is it possible to generate a chart using the excel 2007 engine for a web
page? (output in jpg)...
Click to expand...

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
Click to expand...

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
 
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
/// ------------------------------
 
Back
Top