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 3 3761
"mscir" <ms***@usa.co m> wrote in message
news:10******** *****@corp.supe rnews.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:059519846 5)
- Programming Microsoft Office 2000 Web Components (ISBN:073560794 X)
In addition, there also a help file associated with OWC. Admittedly, it's
not well advertised. It's located at:
<Office Install Directory>\Offi ce\1033\MSOWCVB A.CHM
HTH
-Chris Hohmann
Chris Hohmann wrote: "mscir" <ms***@usa.co m> 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:059519846 5) - Programming Microsoft Office 2000 Web Components (ISBN:073560794 X)
In addition, there also a help file associated with OWC. Admittedly, it's not well advertised. It's located at:
<Office Install Directory>\Offi ce\1033\MSOWCVB A.CHM
HTH -Chris Hohmann
Chris,
Thanks very much. I'll definitely pass this along.
Mike
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! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 empty). I created a .vbs file and put
it in the same directory as the .asp file on the web. The same exact code.
It runs fine. Soon as I call the asp file, it still does nothing. Would
anyone have an idea as to why the .asp has no ability to run this...
|
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 running in COM+ on a separate
server with the SQL database residing on its own server.
I don't really use COM+ for the transactions but more for the DCOM
capabilities and as a way to control the running program. If I need to
compile out a new...
|
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 paste as an Excel object in power point
which links the Excel file to the power point, but this
increases the file size.
Microsoft Power point has a feature called Microsoft
charts that allows to create charts and graphs in
|
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 cells can contain any type of data, but the data has to be coverted to
Double arrays. Currently I read the data from the spreadsheed using OleDB
and put the data into datagrid which is not too bad - takes maybe a minute,
but when I move the data...
|
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 to open the spreadsheet using my
log on credentials since they won't have priviliges to access their particular
file from the network drive. BTW, I am guessing I will have to use HTTP as
this file exists in a Sharepoint document library.
I can...
| |
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 from sheet 1
and draw graphs in various other sheets.
open the specific excel file from asp.net and then plot the data as per
the pre requisite and generate graphs etc from this. I have had a look
at some third party controls
|
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 spreadsheets for
different groups. The spreadsheet formats are the same for each of the
different groups. So I am using a loop to requery the data for the
different groups and create a new spreadsheet for each group. The
three graphs on sheet 2...
|
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 and excel is closed. But there are
some commented lines:
//xlSeries.XValues = xlWs.get_Range("B2", "B4"); // makes com objects, but
which...
|
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 and it seems to me that Excel is far easier to create graphs than Access.
When I use the Get External Data feature of Excel and the dialog box with the tables and queries appears, the query I need is not listed. Is this because the query has...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |