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 could be
to modify the string to be 00123456789_. The disadvantage is that after
the import, I have to remove the "_" from 00123456789
Try using a space before the number, i.e. " 00123456789". I haven't
used Spreadsheet::WriteExcel for A while, but this technique works for
the Win32::OLE method.
_______________________________________________
ActivePerl mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
