Thread

Posted on Wed Jan 11 00:53:20 2006 by surya227
Error PPS 0
i am trying to parse a Excel file using Spreadhsheet-ParseExcel, but it keeps on giving me the PPS Error message. surprisingly, using the same codes, if i run it on a different server it seems to run perfectly. can somebody help as to why this is happening?
Direct Responses: 1611 | 4306 | Write a response
Posted on Wed Jan 11 02:18:06 2006 by jmcnamara in response to 1610
Re: Error PPS 0

If the code runs on one platform but not on the other then you probably have a version problem. Run the following on both platforms to see if it give you any clues:

#!/usr/bin/perl -w print "\n Perl version : $]"; print "\n OS name : $^O"; print "\n Module versions: \n"; my @modules = qw( Spreadsheet::ParseExcel OLE::Storage_Lite ); for my $module (@modules) { my $version; eval "require $module"; if (not $@) { $version = $module->VERSION; $version = '(unknown)' if not defined $version; } else { $version = '(not installed)'; } printf "%21s%-24s\t%s\n", "", $module, $version; }

--
John.
--
Write a response
Posted on Fri Feb 9 23:08:13 2007 by bryanl in response to 1610
Re: Error PPS 0
Hi , I found the same ERROR PPS :0 today, the spreadsheet I had to parse was saved in Excel 2003. I opened and saved the spreadsheet in Excel 2000 and the script executed correctly. I don't know how to fix this from a scripting perspective, Can anybody suggest a better way to workaround this issue?
Direct Responses: 4322 | 5080 | Write a response
Posted on Mon Feb 12 12:16:53 2007 by bryanl in response to 4306
Re: Error PPS 0
This Error seems to occur when the "tracking changes" option within Excel 2003 is enabled. When this option is disabled it is possible to parse the speadsheet.
Write a response
Posted on Tue May 8 11:55:54 2007 by steveberra316 in response to 4306
Re: Error PPS 0
I assume you are uploaded the file to a website first? If so make sure the file is being written to the server in BINMODE. Example: binmode FILE;
Write a response