473,326 Members | 2,438 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

excel charts using asp.net

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

Jul 15 '07 #1
4 1806
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
"Fred" <fr*******@yahoo.comwrote in message
news:%2***************@TK2MSFTNGP04.phx.gbl...
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

Jul 15 '07 #2
"Fred" <fr*******@yahoo.comwrote in message
news:%2***************@TK2MSFTNGP04.phx.gbl...
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...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/Aspos...s/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
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jul 15 '07 #3
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
/// ------------------------------


"Fred" wrote:
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

Jul 16 '07 #4
"Braulio Diez" <br**************@yahoo.eswrote in message
news:D4**********************************@microsof t.com...
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/...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...
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

Jul 16 '07 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: ian castleden | last post by:
From time to time I see requests for some sort of python MS Excel interface/software. I have written just such software 100% python (works with Jython too! at least it did a year ago). It was...
0
by: mscir | last post by:
Date: Thu, 08 Jul 2004 17:02:27 -0700 Organization: Posted via Supernews, http://www.supernews.com Message-ID: <10ero4l3kp2qa65@corp.supernews.com> Reply-To: mscir@usa.com User-Agent: Mozilla/5.0...
10
by: Mark Day | last post by:
Hi All, I am using Access 2000 to generate over 40 Excel charts and pivot tables using early binding to the Excel 9.0 object library. I am finding that if I show the Excel object while processing...
0
by: Rach | last post by:
Hi, Does anyone know how to export charts/graphs from EXCEl into Powerpoint-Microsoft Charts though VBA code. I would like to import the underlying data with the chart as well. I know we can...
1
by: Randall Arnold | last post by:
I'm converting a vbscript program to vb.net. Witht he exception of .net idiosyncrasies, most of it is working well with the same code. My only problem is that some properties and methods are...
5
by: Takeadoe | last post by:
I'm doubtful that the group is unbiased, but I will ask anyhow :o). If one intends to plot lots of data, primarily XY line and scatter plots, and mass produce them (in many cases I will be doing...
3
by: implicate_order | last post by:
Greetings, I'm new to python and am in the process of writing a script to parse some CSV data, spread it across multiple Excel worksheets and then generate charts. I searched the internet to...
3
by: saragoesnuts | last post by:
I have a program that automates to Excel with information in tables. I want to add charts to the excel file (pie charts, bar charts, etc). Is this possible?
0
by: eolmos | last post by:
Hello everyone, I am currently working on a project that requires a webform in asp.net using C# as the code behind. The page must allow the user to create a report in excel. This report must also...
9
by: AGP | last post by:
I have a VB6 application that has an OLE container with an embedded Excel chart. Our office updated to Excel 2007 and now although the app works the charts looks like crap. Since the app is fairly...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.