Re: Importing into Excel

Wed, 08 Feb 2006 10:25:44 -0800

use $worksheet->keep_leading_zeros();

----- Original Message -----
From: "Erich Singer" <[EMAIL PROTECTED]>
To:
Sent: Wed, 8 Feb 2006 08:24:41 -0800
Subject: Importing into Excel


Good Morning

I am using PERL (Spreadsheet::WriteExcel)on Windows to import data into
Excel 2003. Everything is working fine, except when I have to import a
string that contains only numbers, such as 00123456789. It gets
imported as 123456789, e.g. missing the leading 00. A solution could be
to modify the string to be 00123456789_. The disadvantage is that after
the import, I have to remove the "_" from 00123456789_
Any better ideas would be greatly appreciated.
Erich

_______________________________________________
ActivePerl mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs 

_______________________________________________
ActivePerl mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Reply via email to