Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP to Excel Chart problem...
Message
From
06/10/1998 16:45:01
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
VFP to Excel Chart problem...
Miscellaneous
Thread ID:
00144375
Message ID:
00144375
Views:
86
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...
Next
Reply
Map
View

Click here to load this message in the networking platform