Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP to Excel Chart problem...
Message
De
06/10/1998 16:45:01
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
VFP to Excel Chart problem...
Divers
Thread ID:
00144375
Message ID:
00144375
Vues:
87
Has anyone successfully created an Excel chart
from VFP? I am wanting the data feed to a seperate
sheet to feed the chart tab. No luck. Of course, the
problem is with the last line.

ox = crea('excel.application')
ox.workbooks.open('c:\temp\test.xls')
ox.workbooks.add()
ox.charts.add()
ox.activechart.charttype = 1
ox.chartobjects(1).chart.chartwizard(ox.range(ox.sheets(1).cells
(1,1),ox.sheets(1).cells(2,5)),-4100,4,1,0,1,1,"","","","")

Test.xls simply contains data similar to the following.
dep_date Amt
01/01/98 12
01/02/98 10
01/03/98 15
etc...
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform