Date: | Tue, 7 Sep 2004 09:40:34 +0100 |
From: | Richard Shaw <richard [...] aggress.net> |
To: | tony [...] tmtm.com |
Subject: | Spreadsheet::WriteExcel::Simple problem |
Hi Tony,
I hope you don't mind me mailing you directly, i'm having a small issue with your module -
Spreadsheet::WriteExcel::Simple and wondered if you could help ?
I have a very simple script to write some data to an excel file which executes fine,
however the output in the file is completely garbled. The script is as follows:
--
#!/usr/bin/perl
use strict;
use lib "/usr/local/post/perl_libs";
use POSIX qw(strftime);
use Date::Manip;
use Spreadsheet::WriteExcel::Simple;
use Mail::Sender;
my $ss = Spreadsheet::WriteExcel::Simple->new;
$ss->write_bold_row(["Date", "Average CPU Usage", "Maximum CPU Usage", "Average Peak Time CPU Usage", "Efficiency"]);
$ss->write_row(["fish", "cakes"]);
print $ss->data;
open my $file, "> output/test.xls" or die "Unable to open file $!";
print $file $ss->data; #Output the sql to the newly created file.
close($file); #Save the file.
--
I've attached the example output file so you can see whats going on and these are the versions i've got
Spreadsheet::WriteExcel::Simple $VERSION = 0.03
perl v5.8.0
Red Hat Linux release 8.0 (Psyche)
Kind Regards
Richard
Message body not shown because it is not plain text.