473,394 Members | 1,266 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,394 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 3745
"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: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

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.