Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw

problems installing Spreadsheet::WriteExcel

by dannoura (Pilgrim)
on Nov 25, 2003 at 19:00 UTC ( #310019=perlquestion: print w/replies, xml ) Need Help??
dannoura has asked for the wisdom of the Perl Monks concerning the following question:


I ran into some programs trying to install Spreadsheet::WriteExcel. I'm trying to do this on a new machine so I may not have configured ppm and CPAN correctly.

I followed the instructions here to configure ppm to handle the firewall, but it doesn't seem to work. Downloading the package from here and trying to install it with

ppm install <location>

doesn't work either.

When I tried CPAN I managed to locate the module but when CPAN tries to run the test during installation it returns

'test' is not recognized as an internal or external command, operable +program or batch file. test --NOT OK Running make install make test had returned bad status, won't install without force

Does anyone know how to solve this?

Replies are listed 'Best First'.
Re: problems installing Spreadsheet::WriteExcel
by cleverett (Friar) on Nov 25, 2003 at 19:15 UTC
    We need more input here:

    1. Your message indicates you're trying to install this on Windows, I and maybe some others would find it helpful if you told us more about about your platform.
    2. What specifically happens when you run ppm to install the package? Tell us what you've tried that hasn't worked, but also tell us what happened.

    The make command doesn't come with a default Windows installation.

      Sorry. Forgot to mention. I'm running it on WinXP. I downloaded nmake from here, but only after configuring CPAN, so maybe it can't locate it now.

      When I run ppm it simply says

      No matches for 'Spreadsheet::WriteExcel'; see 'help search'.

      Which I think means that it couldn't get over the firewall (since it also can't locate other, common, modules).

        Change the '::' separator to '-', ie: ppm install Spreadsheet-WriteExcel

        If you're running from the ppm prompt, you can search then install by the number of the result.

        What an awkward sentence that was! I'll just paste a screenshot:

        ppm> search WriteExcel Searching in Active Repositories 1. Spreadsheet-WriteEx~ [0.41] (none) 2. Spreadsheet-WriteEx~ [0.42] Write to a cross platform Excel binar +y file 3. Spreadsheet-WriteEx~ [0.42] Write to a cross platform Excel binar +y file 4. Spreadsheet-WriteEx~ [0.09] Convert a database table to an Excel +spreadsh~ 5. Spreadsheet-WriteEx~ [1.01] Create Excel Spreadsheet from XML 6. Spreadsheet-WriteEx~ [1.02] Create Excel Spreadsheet from XML 7. Spreadsheet-WriteEx~ [1.02] Create Excel Spreadsheet from XML 8. Spreadsheet-WriteEx~ [0.03] A simple single-sheet Excel document ppm> install 6
Re: problems installing Spreadsheet::WriteExcel
by Anonymous Monk on Nov 26, 2003 at 05:03 UTC
    I'm trying to do this on a new machine so I may not have configured ppm and CPAN correctly.
    So don't use CPAN or ppm. Use CPANPLUS.
Re: problems installing Spreadsheet::WriteExcel
by Anonymous Monk on Nov 26, 2003 at 05:05 UTC
        Spreadsheet::WriteExcel - Write formatted text and numbers to a
        cross-platform Excel binary file.
        This module requires Perl 5.005 (or later)
        Method 1, standard install with make
        Download the zipped tar file from one of the following:
        Unzip the module as follows or use winzip:
            tar -zxvf Spreadsheet-WriteExcel-0.xx.tar.gz
        The module can be installed using the standard Perl procedure:
            perl Makefile.PL
            make test
            make install    # You may need to be root
            make clean      # or make realclean
        Windows users without a working "make" can get nmake from:
        Method 2, install
        If you have configured you can install the module as
            perl -MCPAN -e "install 'Spreadsheet::WriteExcel'"
        Method 3, ActivePerl ppm
        ActivePerl users can use PPM as follows:
            C:\> ppm
            PPM> set repository tmp
            PPM> install Spreadsheet-WriteExcel
            PPM> quit
        If this fails try the following:
        If both of these fail you should ensure that ppm is working
        correctly. Try to install the File::Slurp module as a test:
            C:\> ppm
            PPM> install File-Test
            PPM> quit
        A failure here will indicate that your ppm isn't configured
        correctly or, more likely, that you are behind a firewall. Have a
        look at the "Using PPM" documentation that comes with
        ActivePerl to see how to resolve these issues.
        Method 4, ActivePerl local ppm
        If the previous ppm methods fail you can try a local ppm install
        as follows. Download the following two files (xx is the most
        recent version number):
        Copy them to a temp directory. There is no need to un-tar or unzip
        the PPM file.
        In the DOS shell change to the temp directory and run ppm:
             C:\> cd c:\temp
             C:\Temp> ppm
             PPM> install Spreadsheet-WriteExcel.ppd
             Install package 'Spreadsheet-WriteExcel.ppd?' (y/N): y
             Retrieving package 'Spreadsheet-WriteExcel.ppd'...
             Writing C:\perl\site\lib\auto\Spreadsheet\WriteExcel\.packlist
             PPM> quit
        The module should now be installed. Note, you will also have to
        install Parse::RecDescent and possibly File::Temp if it isn't
        already installed .
        You can keep up to date with future release by registering as a
        user with Freshmeat and subscribing to
        Spreadsheet::WriteExcel at the project page:
        You will then receive mailed updates when a new version is
        Alternatively you can keep an eye on news://comp.lang.perl.announce
        John McNamara (

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://310019]
Approved by cleverett
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (4)
As of 2017-08-21 16:21 GMT
Find Nodes?
    Voting Booth?
    Who is your favorite scientist and why?

    Results (324 votes). Check out past polls.