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
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