469,282 Members | 2,045 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,282 developers. It's quick & easy.

Excel Graphs from ASP: wrapper? documentation?

I'm trying to find thorough documentation for creating graphs using
serverside Excel from ASP. Any book recommendations?

A well-documented COM wrapper would be nice if it allowed us to create
may different types of graph, e.g. Wind Rose (for wind direction),
thermometer, as well as standard pie, line, bar charts. I've found a few
examples of charting code on websites and at MS, but none of them
contain a thorough explanation, and our database/ASP guy wants more
documentation.

Any book or product recommendations would be appreciated.
Mike

Jul 19 '05 #1
3 3639
"mscir" <ms***@usa.com> wrote in message
news:10*************@corp.supernews.com...
I'm trying to find thorough documentation for creating graphs using
serverside Excel from ASP. Any book recommendations?

A well-documented COM wrapper would be nice if it allowed us to create
may different types of graph, e.g. Wind Rose (for wind direction),
thermometer, as well as standard pie, line, bar charts. I've found a few
examples of charting code on websites and at MS, but none of them
contain a thorough explanation, and our database/ASP guy wants more
documentation.

Any book or product recommendations would be appreciated.
Mike


Learn More about Graphing!
http://www.4guysfromrolla.com/webtec...e/Graphing.asp

Of particular note are the articles on Office Web Components (OWC). I feel
that OWC is a technology that doesn't get the credit it is due. Especially
considering the improvements in OWC for Office XP. For instance, OWC graphs
can be output directly to the Response object (or any other object that
implements the IStream interface). Unfortunately, there is very little by
way of documentation for OWC. Here are two (2) books:

- Professional ASP Programming Guide for Office Web Components: With Office
2000 and Office XP (ISBN:0595198465)
- Programming Microsoft Office 2000 Web Components (ISBN:073560794X)

In addition, there also a help file associated with OWC. Admittedly, it's
not well advertised. It's located at:

<Office Install Directory>\Office\1033\MSOWCVBA.CHM

HTH
-Chris Hohmann



Jul 19 '05 #2
Chris Hohmann wrote:
"mscir" <ms***@usa.com> wrote.
I'm trying to find thorough documentation for creating graphs using
serverside Excel from ASP. Any book recommendations?
A well-documented COM wrapper would be nice if it allowed us to create
may different types of graph, e.g. Wind Rose (for wind direction),
thermometer, as well as standard pie, line, bar charts. I've found a few
examples of charting code on websites and at MS, but none of them
contain a thorough explanation, and our database/ASP guy wants more
documentation.
Any book or product recommendations would be appreciated.
Mike

Learn More about Graphing!
http://www.4guysfromrolla.com/webtec...e/Graphing.asp

Of particular note are the articles on Office Web Components (OWC). I feel
that OWC is a technology that doesn't get the credit it is due. Especially
considering the improvements in OWC for Office XP. For instance, OWC graphs
can be output directly to the Response object (or any other object that
implements the IStream interface). Unfortunately, there is very little by
way of documentation for OWC. Here are two (2) books:

- Professional ASP Programming Guide for Office Web Components: With Office
2000 and Office XP (ISBN:0595198465)
- Programming Microsoft Office 2000 Web Components (ISBN:073560794X)

In addition, there also a help file associated with OWC. Admittedly, it's
not well advertised. It's located at:

<Office Install Directory>\Office\1033\MSOWCVBA.CHM

HTH
-Chris Hohmann


Chris,

Thanks very much. I'll definitely pass this along.

Mike

Jul 19 '05 #3
Also I've got a free barchart ASP class (no components) downloadable
from my Web site at http://www.bullschmidt.com/barchart.asp to help turn
data stored in a table (or SQL statement) into a barchart.

To create a bar chart on a Web page you would include another Web page
called jpschart.asp:
<!--#include file="jpschart.asp"-->

And the trick for using the chart with a recordset is the same concept
as writing data to an HTML table from a recordset and that is this -
within your loop through the recordset you retrieve values such as
objRS("Sales") and in this case write those values to the chart object
instead of writing those values to the HTML table.

Also you may want to check out the following:

Components: Graphics & Charts
http://www.aspin.com/home/components/graphics
Lists components.

Best regards,
J. Paul Schmidt, Freelance ASP Web Designer
http://www.Bullschmidt.com
ASP Designer Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Peter | last post: by
2 posts views Thread by edr | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.