Thread ole32 -> Excel-chart bild einfügen
(6 answers)
Opened by NixIsFix at 2009-05-11 16:55
So funktioniert es bei mir:
Code (perl): (dl
)
1 2 3 4 5 6 7 8 9 10 11 12 my $workbook = $excel -> Workbooks -> Add(); my $sheet = $workbook -> Worksheets( 1 ); my $range = $sheet -> Range( 'A1:G2' ); $range -> {Value} = [ [ qw( 14 24 4 35 26 45 34 ) ], [ qw( 34 25 23 24 34 32 11 ) ] ]; my $chart = $workbook -> Charts -> Add(); $chart -> SetSourceData( { Source => $range, PlotBy => xlRows } ); $chart -> Activate; my $range2 = $chart -> Pictures -> Insert( 'Testbild.jpg' ); $range2 -> ShapeRange -> IncrementLeft( 60 ); $range2 -> ShapeRange -> IncrementTop( 60 ); |