in reply to Leading zero problem in spreadsheet
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
|
|---|
In Section
Seekers of Perl Wisdom