Re: ms OWC Chart Control Demo Code
- From: tbader01 <tbader01@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 16 Jan 2007 15:27:00 -0800
Thanks Paul, but I have No Idea where you are seeing the HTML code!
The text below is Exactly what I see, and there isn't any html code there!
"Paul Randall" wrote:
Hi.
mr_unreliable's script was both attached and appended to the bottom of his
post. Put the HTML into an HTA file and run it.
Split doesn't work well with CVS files because the fields may contain
commas.
Look at the .CHM help files for the version of OWC you installed. The
location depends on the OWC version.
Help file info: http://support.microsoft.com/kb/319793
There is a download for a single comprehensive help file for version 11, but
it may be included with the current version 11 installation.
Search the VBA or comprehensive help file for 'tab' and 'csv' to learn how
to use statements like these to load your data into a spreadsheet:
Spreadsheet1.CSVURL = "file:\test.csv"
Spreadsheet1.ActiveSheet.Range("B10").LoadText "tabfile.txt", Chr$(9)
Google to find examples of charting from the spreadsheet component.
Dynamic chart example: http://www.support.microsoft.com/kb/290348
This shows how to use events associated with the OWCs.
-Paul Randall
"tbader01" <tbader01@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A7CEB482-B79F-4263-B320-7C2BD2B4F9FD@xxxxxxxxxxxxxxxx
Thanks JW for your info on OWC. I never heard of that before, but it looks
pretty neat!
My problem is that I am more experienced with VBScripting, which I just
dragged and dropped files ontop of the VBS file to create graphs out of
the
CSV files using the Excel object, but of course would like to use arrays
to
chart the data (split(strCSVLine,",") ) which I can't figure out /w Excel.
The web sites you gave were pretty useful. It referenced a book called
"Understanding ActiveX and OLE", which I think I really need a better
understanding of. I got it on amazon.com for about $0.60!
PS: I don't see the hta demo that you referenced below!
"mr_unreliable" wrote:
o.k. here is a demo (hta) of the ms owc charting control,
which I assert to be easier and faster than using ms excel
for showing a chart from script.
There are various versions of owc available, depending on
your version of ms office, and/or what you may have
downloaded from microsoft. (The latest owc is version 11,
I think). The demo is using version 10, or "OWC10", from
owc10.dll. If you happen to have another version installed,
you will have to re-jigger the guid to match what you have.
The demo shows the owc chart as a "visual" control, i.e.,
sited on an hta (html) form (er, page?). In certain (many)
other cases of example code, you will see owc chart used as
a "logical", (or hidden) control. In those cases it is not
instantiated by an object tag, rather it is instantiated
via code:
CreateObject("OWC10.ChartSpace")
The programmer will than get the owc chart control to generate
the graphic (unseen), and using the "ExportPicture" method, to
write it out to a file (say a "gif" file). The gif file is then
displayed in an image tag (if html), or maybe in an image control
(if vb).
The demo hta uses the owc control go generate the graphic
"straight up", without going through the intermediate step
of generating a file.
cheers, jw
____________________________________________________________
You got questions? WE GOT ANSWERS!!! ..(but,
no guarantee the answers will be applicable to the questions)
- References:
- Re: ms OWC Chart Control Demo Code
- From: Paul Randall
- Re: ms OWC Chart Control Demo Code
- Prev by Date: Does VBscript support " & _" for long strings?
- Next by Date: Re: Does VBscript support " & _" for long strings?
- Previous by thread: Re: ms OWC Chart Control Demo Code
- Next by thread: Re: ms OWC Chart Control Demo Code
- Index(es):
Relevant Pages
|
