473,327 Members | 2,103 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,327 software developers and data experts.

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 3744
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
by: Leo | last post by:
Hi I had asekd previously a question qith regards to running a DLL file from ASP. It was not running for me. Bo error returned, nothing, Just an empty string (when it should have not been...
3
by: Mike | last post by:
I have been developing ASP applications for quite a while now. Most of the apps that I deploy are a typical n-tier setup. ASP GUI on a web server, Business and Data Components written in VB6...
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...
4
by: Peter | last post by:
Does anyone know a way to import excel data very fast? I have spreadsheet data that has to be processed, the spreadsheet has 256 columns and 20,000 rows of data. That's 5,120,000 cells. The...
2
by: Peter S. | last post by:
I have an ASP.NET page that invokes a web control written in C#. What I want to do is (based on the session ID) display a certain spreadsheet that exists on a network drive. I want the webcontrol...
2
by: edr | last post by:
Hi, I have a excel file templete, where i need to populate the raw data in the one of the sheet with the specific predefined format. based on the that data, a VBA program will fetch the data...
1
by: Mitch | last post by:
I am using Access to create an Excel spreadsheets with graphs related to rows on the sheet1 to the graph on sheet2. I am using the same data but different subsets of the data to make different...
10
by: Hendri Adriaens | last post by:
Hi, I'm trying to automate the creation of an excel file via COM. I copied my code below. I read many articles about how to release the COM objects that I create. The code below runs just fine...
15
by: OzNet | last post by:
I have a query (with calculated fields) in Access (2007) and the data changes depending on the dates and staff person selected. I need to produce a series of graphs based on the data in this query...
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
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
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...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
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.