--- trunk/bin/BackupPC_xls_report 2005/08/19 21:52:43 41 +++ trunk/bin/BackupPC_xls_report 2005/08/19 22:12:56 43 @@ -48,11 +48,17 @@ my $duration_format = $workbook->add_format(num_format => 'hh:mm:ss'); my $header_format = $workbook->add_format(color => 'gray'); my $pcnt_format = $workbook->add_format(num_format => '0.0%'); +my $size_format = $workbook->add_format(num_format => '#0'); my $formats = { duration => $duration_format, sizeNewRatio => $pcnt_format, sizeExistRatio => $pcnt_format, + size => $size_format, + sizeNew => $size_format, + sizeExist => $size_format, + sizeNewComp => $size_format, + sizeExistComp => $size_format, }; my $bpc = BackupPC::Lib->new || die; @@ -98,7 +104,7 @@ $f =~ s/##/($row+1)/ge; $worksheet->write($row, $i, $f, $formats->{$n}); } else { - $worksheet->write($row, $i, $backup->{ $cols[$i] }); + $worksheet->write($row, $i, $backup->{$col}, $formats->{$col}); } } $row++;