RE: Importing into Excel

Wed, 08 Feb 2006 13:20:52 -0800

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 PM
To: Erich Singer; [EMAIL PROTECTED]; Todd Beverly
Cc: [email protected]
Subject: RE: Importing into Excel

The way I accomplish this is to write the data to an SQL table and then do queries for the specific tab of the desired worksheet.  Depending upon how many tabs it can get a bit messy with all of the while loops - but it eliminates the manual process of pasting.
 
Ken
 
 
Ken Barker
IT Lead
Tel: 314-213-7927
1100 Corporate Square
St. Louis, MO 63132
[EMAIL PROTECTED]

From: [EMAIL PROTECTED] on behalf of Erich Singer
Sent: Wed 2/8/2006 1:36 PM
To: [EMAIL PROTECTED]; Todd Beverly
Cc: [email protected]
Subject: RE: Importing into Excel

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: [email protected]
Subject: Re: Importing into Excel

use $worksheet->keep_leading_zeros();

----- Original Message -----
From: "Erich Singer"
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


______________________________________________________________________
This e-mail has been scanned by MCI Managed Email Content Service, using Skeptic(tm) technology powered by MessageLabs. For more information on MCI's Managed Email Content Service, visit http://www.mci.com.
______________________________________________________________________
The information in this e-mail is confidential and intended solely for the person to whom it is addressed. Should you receive this message unintentionally, please do not use the contents herein and notify the sender immediately by return e-mail and then delete the message from your computer. Americall Group, Inc. cannot be held responsible or liable in any way whatsoever for and/or in connection with any consequences and/or damage resulting from the dispatch and receipt of this e-mail and the content of this e-mail. Americall Group, Inc. takes no responsibility for any computer virus that might be transferred by way of this email. 
_______________________________________________
ActivePerl mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs

Reply via email to