Re: MS Excel 2007 never dies - or at least the process wont

The following is not a solution; rather thoughts and suggestions as I'm unable to replicate your environment.

I was originally going to suggest that an alternative might be Spreadsheet::XLSX which the documentation describes as: "Perl extension for reading MS Excel 2007 files".

However, I noticed your perl -V output has "... perl5 (5.0 patchlevel 5 subversion 03) ... Compiled at Nov 2 1999 ...". As Spreadsheet::XLSX source code has use 5.006000;, you won't be able to use this with your current (12-year old) version of Perl.

This led me to thinking that there might be some some incompatibility between your 1999 Perl and 2007 Excel. If you add use warnings; (after use strict;), you may get some output indicating such a problem.

While I appreciate that upgrading Perl will not be a trivial task, I would recommend you look at doing so.

P.S. For future reference, the perl -V output would have been much easier to read if wrapped in <code>...</code> tags.

-- Ken

Comment on Re: MS Excel 2007 never dies - or at least the process wont Select or Download Code

Replies are listed 'Best First'.
Re^2: MS Excel 2007 never dies - or at least the process wont by otism (Initiate) on Aug 25, 2011 at 16:05 UTC
Thanks Ken - and would love to update the environment but it's a far more extensive environment than just my virtual station on the server that will be required to run the code. The script this is derived from is part of a package deliverable for repeated use and unfortunately the deadline for the initial completion of the script for the procedure at hand is rather more pressing than a broadcast environment update would support.	[reply]

Replies are listed 'Best First'.

Re^2: MS Excel 2007 never dies - or at least the process wont
by otism (Initiate) on Aug 25, 2011 at 16:05 UTC

Thanks Ken - and would love to update the environment but it's a far more extensive environment than just my virtual station on the server that will be required to run the code. The script this is derived from is part of a package deliverable for repeated use and unfortunately the deadline for the initial completion of the script for the procedure at hand is rather more pressing than a broadcast environment update would support.

[reply]