RE: Importing into Excel

[Erich Singer]

Hello

 

I would like to thank  you for your suggestions.

However, in the meantime I found a solution.

1 Delete (if any) leading and trailing spaces from the original string.

2 Replace  original string 00123456789  with ="00123456789".

 

With this opportunity I would like to ask another question. My final report should be one Excel file with many worksheets. As far as I know, Spreadsheet::WriteExcel, does not allow to write data to an existing Excel file. My solution is to import the data into separate Excel files and than "copy and paste" manually from the various Excel files into the final report.

Any ideas for a better solution would be appreciated

Erich

---

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 08, 2006 1:56 PM
To: Erich Singer
Cc: activeperl@listserv.ActiveState.com
Subject: Re: Importing into Excel

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
ActivePerl@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

_______________________________________________
ActivePerl mailing list
ActivePerl@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs