Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Printing Msgraph
Message
De
10/04/2001 06:00:09
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
09/04/2001 14:37:00
Information générale
Forum:
Visual FoxPro
Catégorie:
Contrôles ActiveX en VFP
Divers
Thread ID:
00493112
Message ID:
00493944
Vues:
26
Pardon me for jumping in.
Scott,
You can find object model for MSGraph5 and up. Search for a file named vba_grp*.*. For MSGraph5 as far as I remember name was different and was located in MSGraph dir. Later versions seem to be located under Office dir (and as I remember during install VBA help is optional).
For your problem syntax would be :

myform.myGraph.object.application.datasheet

However I think this is related with your web chart problem. IMHO Excel is way better and faster than MSGraph. MSGraph9 and up has PEM almost identical to Excel's. So if your version is 9+ you could simply use Excel developer help too.
As another side note if you would use MSGraph instead of datasheet use code like :
#DEFINE TAB_ CHR(9)
#DEFINE CRLF CHR(13)+CHR(10)
* Data prepare *
wait window nowait "Filling cell values..."
MCGDATA = ""
nCols = fcount()
for ix = 1 to nCols
  MCGDATA = MCGDATA + iif(empty(MCGDATA),"",TAB_)+field(ix)
endfor
MCGDATA = MCGDATA + CRLF
scan
  for ix = 1 to nCols
    MCGDATA = MCGDATA + iif(ix=1,"",TAB)+nvl(transform(evaluate(field(ix))),"")
  endfor
  MCGDATA = MCGDATA + CRLF
endscan
* Data prepare *

create cursor testgen (genfld1 g)
append blank
append general genfld1 class "msgraph" data MCGDATA
Filling cell values using datasheet is much slower.
Cetin

>Hi Vlad.
>
>I'm intereted in your approach on this for msgraph and can get the oleboundcontrol working on the form ok. I'm having a little trouble seeing down into the object model ... just looked at it with the debugger.
>
>Is there a help file for the model that you know of?
>
>form.oleboundcontrol.object.datasheet returns the error unknown name ... so, I don't have the model path correct.
>
>... could you provide a couple of lines so that I can get this right?
>
>Thx, Scott :-D
>
>ps; To save the graph to a file ... I've been shown that the Export method works well for this: object.Export("filename.gif","GIF") .. nicely creates a GIF file of the graph.
>
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform