Thread Mit Perl in Excel ein Bild einfügen (3 answers)
Opened by Cathore at 2009-09-12 23:37

havi
 2009-09-29 15:15
#126333 #126333
User since
2003-08-04
2036 Artikel
BenutzerIn
[Homepage]
user image
Code (perl): (dl )
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
#!/usr/bin/perl

use warnings;
use strict;
use Win32::OLE::Const 'Microsoft Excel';

$Win32::OLE::Warn = 3;

my $excel = Win32::OLE->GetActiveObject('Excel.Application') ||
            Win32::OLE->new('Excel.Application', 'Quit');
my $book  = $excel->Workbooks->Open("C:\\dev\\test.xls");

$book->ActiveSheet->Pictures->Insert("C:\\dev\\Logo.png");

$book->Close;

$excel->Quit();

View full thread Mit Perl in Excel ein Bild einfügen