Thread ole32 -> Excel-chart bild einfügen (6 answers)
Opened by NixIsFix at 2009-05-11 16:55

Gast Gast
 2009-05-11 20:09
#121498 #121498
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 );

View full thread ole32 -> Excel-chart bild einfügen