Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
PerlMonks  

Leading zero problem in spreadsheet

by sen (Hermit)
on Sep 27, 2012 at 06:35 UTC ( #995925=perlquestion: print w/ replies, xml ) Need Help??
sen has asked for the wisdom of the Perl Monks concerning the following question:

Hi All,

I am using Spreadsheet::ParseExcel::SaveParser::Workbook module(saveas method) for spreadsheet copy. Is there anyway to keep the leading zero's in the copied spreadsheet. Please advice.

Thanks in advance.

Comment on Leading zero problem in spreadsheet
Re: Leading zero problem in spreadsheet
by Anonymous Monk on Sep 27, 2012 at 06:48 UTC
Re: Leading zero problem in spreadsheet
by davies (Vicar) on Sep 27, 2012 at 10:04 UTC

    I haven't followed AnonyMonk's links & I don't know Spreadsheet:ParseExcel. However, there are two methods of dealing with leading zeros. The first is to save the string as text. The second is to format the numeric value to show a specified number of characters. I know it's not your weapon of choice, but in Re: Formatting cells in Excel I show both these techniques using Win32::OLE. Converting that to S::PE is left as an exercise for the reader!

    Regards,

    John Davies

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://995925]
Approved by Athanasius
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (10)
As of 2014-07-10 09:53 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When choosing user names for websites, I prefer to use:








    Results (205 votes), past polls