Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VFP 7.0 AND EXCEL CHARTS PROBLEM(ARRAYS)

Status
Not open for further replies.

738262

Programmer
Mar 3, 2002
41
CY
Hi all,
I have a Problem with excel charts.
this is my code

LOCAL xlapp as Excel.Application
LOCAL xlwrk as Excel.Workbook
LOCAL xlsht as Excel.Worksheet
LOCAL XLSERIES AS Excel.Series
xlapp=CREATEOBJECT("Excel.Application")
xlwrk=xlapp.Workbooks.Add()
xlsht=xlwrk.Sheets(1)
xlrow=53
xlchart1=xlsht.ChartObjects.add(0,0, 750, 400)
Xlchart1.Chart.ChartWizard(xlsht.RANGE("K4:K"+ALLTRIM(STR(XLROW))),4,,2,0,0,.T.,;
"title")
xlSeries=Xlchart1.Chart.seriescollection.newseries()
myArray="={0.17"+REPLICATE(",0.17",xlrow-4)+"}"
xlseries.values=myarray
xlapp.visible=.t.

My problem is that is the myArray String length is more than 255 characters I get an error. Is there a way to solve this?

Thank you
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top