Hey, thanks! I got it working now. Works great.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Darrell
Gammill
Sent: Sunday, May 09, 2004 10:04 PM
To: Gary Nielson; [EMAIL PROTECTED]
Subject: RE: Help with Spreadsheet::WriteExcel
http://search.cpan.org
n' verses my
using '$_'. I just read somewhere that using '$_' was a little more
efficient.
-Original Message-
From: Gary Nielson [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 08, 2004 6:05 PM
To: Darrell Gammill; [EMAIL PROTECTED]
Subject: RE: Help with Sprea
L PROTECTED] On Behalf Of Gary
Nielson
Sent: Saturday, May 08, 2004 4:36 PM
To: 'Gary Nielson'; [EMAIL PROTECTED]
Subject: RE: Help with Spreadsheet::WriteExcel
Here's an update... I have been playing around with the spreadsheet
converted by Spreadsheet::WriteExcel from an ASCII tab-d
[EMAIL PROTECTED]
Subject: RE: Help with Spreadsheet::WriteExcel
Here's an update... I have been playing around with the spreadsheet
converted by Spreadsheet::WriteExcel from an ASCII tab-delimited file.
The
first column is a date, yet I notice when checking cell formatting that
it
is in general fo
ow to
dictate in my script that the first column of every row be in date format as
in 3/14/2004. Any help appreciated.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Gary
Nielson
Sent: Saturday, May 08, 2004 11:09 AM
To: [EMAIL PROTECTED]
Subject: Help
I am using Spreadsheet::WriteExcel to get all files in a directory and
convert them from tab-delimited text to xls format. When I import them
manually, my subsequent formula works fine. However, when I use the same
formula on the converted file, I get a #DIV/0!. I notice that in the last
cell on ea