Skip Menu |

This queue is for tickets about the Spreadsheet-WriteExcel-Simple CPAN distribution.

Report information
The Basics
Id: 9179
Status: resolved
Priority: 0/
Queue: Spreadsheet-WriteExcel-Simple

People
Owner: Nobody in particular
Requestors: richard [...] aggress.net
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



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
Download test.xls
application/excel 6.6k

Message body not shown because it is not plain text.

[richard@aggress.net - Mon Dec 27 11:32:15 2004]: Show quoted text
> 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 ?
Sorry for the delay in getting back to you on this one. I've been completely unable to replicate your problem. Your excel file is indeed garbage, but when I run your script I get a perfectly fine .xls If this is still an issue for you, can you try using the ->save() method rather than writing the file yourself to see if that makes any difference. Thanks Tony