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