Yet another Spreadsheet::WriteExcel install problem

[jbeadles]

Howdy Jim,

I'm also having a Spreadsheet::WriteExcel install problem in
Activestate Perl 5.10.0. I'm working on machines that are behind a
proxy that is not visible to me, and per policy, will not be made
available to me. This means that I cannot make PPM work to install
modules. Instead, I have had to manually download and install 25
individual modules. WriteExcel is the last one I need and I cannot
make it work no mater what I do. I was able to make it work with 5.8
in the past somehow, but can't figure it out now.

The problem seems to be that I can't get a complete zip file
containing the entire version for this release. I've attempted to
assemble one using the PPD that you have on your web site with the old
files, but this does not work. PPM says that it is unpacking files in
the site area, but then stops. I've also tried modifying the old PPD
for this release, but this does not work either.

What can I do now? Any assistance is greatly appreciated.

[jmcnamara]

On Apr 15, 9:34 pm, jbeadles <jbead...@pobox.com> wrote:
> Howdy Jim,
>
> I'm also having a Spreadsheet::WriteExcel install problem in
> Activestate Perl 5.10.0. I'm working on machines that are behind a
> proxy that is not visible to me, and per policy, will not be made
> available to me. This means that I cannot make PPM work to install
> modules. Instead, I have had to manually download and install 25
> individual modules. WriteExcel is the last one I need and I cannot
> make it work no mater what I do. I was able to make it work with 5.8
> in the past somehow, but can't figure it out now.

Hi,

You should be able to do a local ppm install as follows (the trace
below is from an actual install):

Download the following 2 files. Note: do not click on these links
directly, do a right click and "save as".


http://homepage.eircom.net/~jmcnamara/perl/Spreadsheet-WriteExcel.ppd
http://homepage.eircom.net/~jmcnamara/perl/Spreadsheet-WriteExcel-2.21-PPM.tar.gz

Copy the files to some directory. The example below uses "C:\Temp
\ppm":


C:\Temp\ppm>dir
...
15/04/2008 23:24 204,045 Spreadsheet-WriteExcel-2.21-
PPM.tar.gz
15/04/2008 23:24 1,659 Spreadsheet-WriteExcel.ppd
...

The perl version used was 5.10 but this should work for other versions
as well:

C:\Temp\ppm>perl -v

This is perl, v5.10.0 built for MSWin32-x86-multi-thread
(with 3 registered patches, see perl -V for more detail)
...

Run the ppm install command:

C:\Temp\ppm>ppm install Spreadsheet-WriteExcel.ppd

Unpacking Spreadsheet-WriteExcel-2.21...done
Generating HTML for Spreadsheet-WriteExcel-2.21...done
Updating files in site area...done
2 files unchanged
24 files updated

The module should now be installed:

C:\Temp\ppm>perl -MSpreadsheet::WriteExcel -e "print
Spreadsheet::WriteExcel->VERSION()"
2.21


If that still fails for some reason try the unix style install:

Unzip and untar the CPAN distro (not the ppm):

perl Makefile.PL
make
make test
make install

You can use nmake instead of make:

ftp://ftp.microsoft.com/Softlib/MSLFILES/nmake15.exe

I use the above method all the time since it generally works
everywhere.


As an aside I would note that despite the usefulness of ppm it causes
almost all of the installation problems that Spreadsheet::WriteExcel
users report. :-(

John.
--

[jbeadles]

Ah, got it without having to do a make. I didn't know ppm would do an
install with the tar in the same subdir as the ppd file. Fantastic,
this means I can actually have all the modules I need for a project!
Thank you sir! Spreadsheet-WriteExcel has been such a hugely useful
module I don't know what I'd do without it.

On Apr 15, 5:48 pm, jmcnamara <jmcnam...@cpan.org> wrote:
> On Apr 15, 9:34 pm, jbeadles <jbead...@pobox.com> wrote:
>
> > Howdy Jim,
>
> > I'm also having a Spreadsheet::WriteExcel install problem in
> > Activestate Perl 5.10.0.  I'm working on machines that are behind a
> > proxy that is not visible to me, and per policy, will not be made
> > available to me.  This means that I cannot make PPM work to install
> > modules.  Instead, I have had to manually download and install 25
> > individual modules.  WriteExcel is the last one I need and I cannot
> > make it work no mater what I do.  I was able to make it work with 5.8
> > in the past somehow, but can't figure it out now.
>
> Hi,
>
> You should be able to do a local ppm install as follows (the trace
> below is from an actual install):
>
> Download the following 2 files. Note: do not click on these links
> directly, do a right click and "save as".
>
>    http://homepage.eircom.net/~jmcnamara/perl/Spreadsheet-WriteExcel.ppd

>    http://homepage.eircom.net/~jmcnamara/perl/Spreadsheet-WriteExcel-2.2...