Leading zero problem in spreadsheet

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

Replies are listed 'Best First'.
Re: Leading zero problem in spreadsheet by davies (Monsignor) 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	[reply]
Re: Leading zero problem in spreadsheet by Anonymous Monk on Sep 27, 2012 at 06:48 UTC
leading-zeros Spreadsheet::ParseExcel -> http://search.cpan.org/perldoc/Spreadsheet::WriteExcel#keep_leading_zeros() grep SaveAs ... http://cpansearch.perl.org/src/JMCNAMARA/Spreadsheet-ParseExcel-0.59/lib/Spreadsheet/ParseExcel/SaveParser/Workbook.pm Nope, there is no way short of patching SaveAs (for Spreadsheet::ParseExcel::SaveParser::Workbook) to use keep_leading_zeros option	[reply]