Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
PerlMonks  

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:

hi,

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?

Comment on problems installing Spreadsheet::WriteExcel
Select or Download Code
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
    http://search.cpan.org/src/JMCNAMARA/Spreadsheet-WriteExcel-0.42/INSTALL
    ======================================================================
    NAME
    
        Spreadsheet::WriteExcel - Write formatted text and numbers to a
        cross-platform Excel binary file.
    
    ======================================================================
    REQUIREMENTS
    
        This module requires Perl 5.005 (or later)
        Parse::RecDescent
            http://search.cpan.org/search?dist=Parse-RecDescent
        File::Temp
            http://search.cpan.org/search?dist=File-Temp
    
    
    ======================================================================
    INSTALLATION
    
        Method 1, standard install with make
        ====================================
        Download the zipped tar file from one of the following:
            http://search.cpan.org/search?dist=Spreadsheet-WriteExcel
            http://theoryx5.uwinnipeg.ca/mod_perl/cpan-search?idinfo=154
            ftp://ftp.funet.fi/pub/languages/perl/CPAN/authors/id/J/JM/JMCNAMARA/
    
        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
            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:
        
            ftp://ftp.microsoft.com/Softlib/MSLFILES/nmake15.exe
    
    
        Method 2, CPAN.pm install
        =========================
        If you have CPAN.pm configured you can install the module as
        follows:
    
            perl -MCPAN -e "install 'Spreadsheet::WriteExcel'"
    
    
        Method 3, ActivePerl ppm
        ========================
        ActivePerl users can use PPM as follows:
    
            C:\> ppm
            PPM> set repository tmp http://homepage.eircom.net/~jmcnamara/perl
            PPM> install Spreadsheet-WriteExcel
            PPM> quit
            C:\>
    
        If this fails try the following:
    
            PPM>install http://homepage.eircom.net/~jmcnamara/perl/Spreadsheet-WriteExcel.ppd
    
        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
            C:\>
    
        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):
    
            http://homepage.eircom.net/~jmcnamara/perl/Spreadsheet-WriteExcel.ppd
            http://homepage.eircom.net/~jmcnamara/perl/Spreadsheet-WriteExcel-0.xx-PPM.tar.gz
    
        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
             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 .
    
    
    ======================================================================
    UPDATES
    
        You can keep up to date with future release by registering as a
        user with Freshmeat http://freshmeat.net/ and subscribing to
        Spreadsheet::WriteExcel at the project page:
        http://freshmeat.net/projects/writeexcel/
    
        You will then receive mailed updates when a new version is
        released.
    
        Alternatively you can keep an eye on news://comp.lang.perl.announce
    
    ======================================================================
    AUTHOR
    
        John McNamara (jmcnamara@cpan.org)
    
    

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://310019]
Approved by cleverett
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (8)
As of 2014-12-26 05:54 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (165 votes), past polls