Thread Spreadsheet::WriteExcel - Bedingte Formatierung (5 answers)
Opened by Gast at 2008-03-26 12:06

renee
 2008-03-27 09:53
#107526 #107526
User since
2003-08-04
14371 Artikel
ModeratorIn
[Homepage] [default_avatar]
Gast+2008-03-26 20:05:06--
(kleiner Wermutstropfen: man kann damit keine Formatvorlagen erstellen.)


Meinst Du das so?

Code (perl): (dl )
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
#! /usr/bin/perl -w

use strict;

use Spreadsheet::WriteExcel;

my $workbook = new Spreadsheet::WriteExcel('hallo.xls');
die "Problems creating new Excel file: $!" unless defined $workbook;

my $sheet = $workbook -> add_worksheet();
my $green = $workbook -> add_format( bg_color => 'green' );
my $blue  = $workbook -> add_format( bg_color => 'blue' );
my $red   = $workbook -> add_format( bg_color => 'red' );

my $cell = 0;
for( 100, 10, 5, 30 ){
    my $format = $green;
    if( $_ < 10 ){
        $format = $red;
    }
    elsif( $_ > 10 ){
        $format = $blue;
    }
    $sheet -> write(0, $cell++, $_, $format);
}

$workbook -> close() or die "Error closing file: $!";
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 Spreadsheet::WriteExcel - Bedingte Formatierung