XP is just a number | |
PerlMonks |
Writing a number to a cell using Spreadsheet::WriteExcelby ColtsFoot (Chaplain) |
on Oct 25, 2002 at 09:56 UTC ( [id://207945]=perlquestion: print w/replies, xml ) | Need Help?? |
ColtsFoot has asked for the wisdom of the Perl Monks concerning the following question:
One of the columns in my database contains an id which is 8 digits long It can take the form What I want is for the leading zeros to be maintained. So I created a format using the set_num_format method and passing '@' as a parameter. The code is as follows When I look at the spreadsheet in M$ Excel the column contains the following All the leading zeros have gone. Please can someone tell me what I am missing. I been right through the documentation, that's where I found the '@' parameter. Thanks
Back to
Seekers of Perl Wisdom
|
|