excel charts using asp.net

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
 
M

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
 
G

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,904
Latest member
HealthyVisionsCBDPrice

Latest Threads

Top