Thread In bestehendes Excel sheet schreiben (1 answers)
Opened by fritz at 2006-09-08 18:35

renee
 2006-09-08 19:15
#69599 #69599
User since
2003-08-04
14371 Artikel
ModeratorIn
[Homepage] [default_avatar]
Code: (dl )
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
#!/usr/bin/perl

use strict;
use warnings;
use Win32::OLE;

my $file = 'C:\voller\pfad\zu\Mappe1.xls';

my $excel = Win32::OLE->new('Excel.Application','Quit') or die $!;
my $workbook = $excel->Workbooks->Open($file);
my $sheet = $workbook->Worksheets(1);

$sheet->Range("b1")->{Value} = "Neuer Wert";

$excel->Save();
OTRS-Erweiterungen (http://feature-addons.de/)
Frankfurt Perlmongers (http://frankfurt.pm/)
--

Unterlagen OTRS-Workshop 2012: http://otrs.perl-services.de/workshop.html
Perl-Entwicklung: http://perl-services.de/

View full thread In bestehendes Excel sheet schreiben