Re: Importing into Excel

2006-02-09 Thread Josh . Perlmutter
Reposting for the list since it was caught up due to a change at my company's end. Just another potential solution that some might like. [EMAIL PROTECTED] wrote on 02/08/2006 03:05:15 PM: >3. Importing into Excel (Erich Singer) >6. Re: Importing into Excel (T

RE: Importing into Excel

2006-02-08 Thread Erich Singer
Ken Thank you for your great idea. I did not think into this direction Erich From: Ken Barker [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08, 2006 3:40 PMTo: Erich Singer; [EMAIL PROTECTED]; Todd BeverlyCc: activeperl@listserv.ActiveState.comSubject: RE: Importing into Excel

RE: Importing into Excel

2006-02-08 Thread Ken Barker
Lead Tel: 314-213-7927 1100 Corporate Square St. Louis, MO 63132 [EMAIL PROTECTED] From: [EMAIL PROTECTED] on behalf of Erich SingerSent: Wed 2/8/2006 1:36 PMTo: [EMAIL PROTECTED]; Todd BeverlyCc: activeperl@listserv.ActiveState.comSubject: RE: Importing into Excel Hello   I would like to

RE: Importing into Excel

2006-02-08 Thread Deane . Rothenmaier
TED] 02/08/2006 13:36                 To:        <[EMAIL PROTECTED]>, "Todd Beverly" <[EMAIL PROTECTED]>         cc:        activeperl@listserv.ActiveState.com         Subject:        RE: Importing into Excel Hello   I would like to thank  you for your suggestions. However, in the me

RE: Importing into Excel

2006-02-08 Thread Erich Singer
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 PMTo: Erich SingerCc: activeperl@listserv.ActiveState.comSubject: Re: Importing into

Re: Importing into Excel

2006-02-08 Thread Todd Beverly
Erich Singer wrote: 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 cou

Re: Importing into Excel

2006-02-08 Thread kcbarker
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. Everythi