#! /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 $format= $workbook -> add_format(); $format -> set_num_format('[red][>50]General;[blue][<50]General;[green]General'); my $format_title= $workbook -> add_format(); $format_title -> set_font('Arial'); $format_title -> set_size(14); # usw. $sheet -> set_row(0, 20, $format_title); foreach my $row (1..10){ foreach my $col (0..1){ $sheet -> write($row, $col, undef); } my $r = $row + 1; $sheet -> write($row, 2, "=A$r+B$r", $format); } $workbook -> close() or die "Error closing file: $!";