Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
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.

Replies are listed 'Best First'.
Re: Leading zero problem in spreadsheet
by davies (Parson) 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

Re: Leading zero problem in spreadsheet
by Anonymous Monk on Sep 27, 2012 at 06:48 UTC

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 all is quiet...

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (10)
As of 2017-01-18 20:36 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Do you watch meteor showers?




    Results (163 votes). Check out past polls.