RE: Warnings with Spreadsheet::WriteExcel

Never mind guys.

I figured it out.=20

The row and col value were not set and as a result I got a screenful
:D....

Thanks for any time you spent on this issue.

Nand Kishore

-----Original Message-----
From: NandKishore.Sagi [mailto:NandKishore.Sagi@target.com]=20
Sent: Thursday, July 29, 2004 3:33 PM
To: beginners@perl.org
Subject: RE: Warnings with Spreadsheet::WriteExcel
Importance: High


I guess the script was not recieved by you guys. Here is the script I
have written.
=20
#! /opt/3d/bin/perl -w
=20
use strict ;
use warnings ;
use Spreadsheet::WriteExcel;
=20
my $workbook ;
my $worksheet ;
my $format ;
my $row ;
my $col ;
my $host ;
=20
$workbook =3D Spreadsheet::WriteExcel->new("dclist.xls") ;
die "Problems creating new Excel file: $!" unless defined $workbook;
=20
$format =3D $workbook->add_format(); # Add a format $format->set_bold();
$format->set_color('red'); $format->set_align('left');
=20
for my $host qw(app0552 app0555 app0557 app0556 app0558 app0560 app0579
app0580 app0587 app0588 app3801 app3803 app3804) {
$worksheet =3D $workbook->add_worksheet($host) ;
$worksheet->write($row , $col , "This is for DC $host" ,
$format); }

-----Original Message-----
From: NandKishore.Sagi [mailto:NandKishore.Sagi@target.com]=20
Sent: Thursday, July 29, 2004 3:27 PM
To: beginners@perl.org
Subject: Warnings with Spreadsheet::WriteExcel
Importance: High
=09
=09
Hi All ,
=20
I am in process of generating some statistics for
different unix boxes. I would like to generate excel workbook with a
single worksheet for each box. I had written a test script to create the
excel sheet. I was able to create the excel sheet but I encountered some
warnings message as the script was executing. I have herewith attached
the script and the warning messages. There is no problem right now but I
was just wondering why so many error messages popped up.=20
=20
Also I had just now installed the module. So is it
that the installation was wrong or partial ? I did not see the
installation progress. My mistake.
=20
Thanks for any inputs.
=20
Thanks and Regards
Nand Kishore S
=20
Nand Kishore Sagi
ART Support Team
(612)-304-BART