in reply to Re: Re: Re: Re: Re: Question about Win32::OLE and Excel
in thread Question about Win32::OLE and Excel

UPDATE: Why are my linebreaks missing? I don't understand whythe following code does not what it is suposed to to: #My Range: my $RangeSting = "A$HeaderRow:A$ToIndex,D$HeaderRow:D$ToIndex,F$HeaderRow:F$ToIndex,H$HeaderRow:H$ToIndex"; #Printed example is: A2:A8,D2:D8,F2:F8,H2:H8 #then a chart is created: my $Chart = $Excel->Charts->Add; $Chart->{ChartType} = xlColumnClustered; $Chart->SetSourceData({Source => $currentsheet->Range($RangeSting) , PlotBy => xlColumns}); But then The chart is empty and I don't understand why... when I record a makro exactly the same is standing there: eg.: ActiveChart.SetSourceData Source:=Sheets("INF1").Range( _ "A2:A8,D2:D8,F2:F8,H2:H8"), PlotBy:=xlColumns I don't see my mistake here... please help me..
  • Comment on Re: Re: Re: Re: Re: Re: Question about Win32::OLE and Excel