Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re: Extracting data from an excel file

by Tanalis (Curate)
on Jun 26, 2003 at 08:32 UTC ( [id://269153]=note: print w/replies, xml ) Need Help??


in reply to Extracting data from an excel file

It might be worth taking a look at Spreadsheet::ParseExcel - that seems to do most of what you say you'll need.

-- Foxcub
#include www.liquidfusion.org.uk

Replies are listed 'Best First'.
Re: Re: Extracting data from an excel file
by blackadder (Hermit) on Jun 26, 2003 at 09:35 UTC
    Thanks for that, but I don't think I have the module Spreadsheet::ParseExcel installed on my PC. Because I get this msg;

    Can't locate Spreadsheet/ParseExcel.pm in @INC (@INC contains: C:/Perl/lib C:/Perl/site/lib .) at C:\scripts\test.pl line 2.
    BEGIN failed--compilation aborted at C:\scripts\test.pl line 2.

    I also have a problem with using PPM. Every time I type ppm i get this error,

    C:\>ppm
    The name specified is not recognised as an Internal or external command, operable program or batch file.

    then I add the extension .bat and I try it as ppm.bat. But I get the following error,

    C:\>ppm.bat
    The name specified is not recognised as an Internal or external command, operable program or batch file.
    You do not have Perl in your PATH.

    here I check the path and I get,

    C:\>path
    PATH=C:\Perl\bin\;C:\Perl\;C:\Perl\bin\;C:\WINNT\system32;C:\WINNT;C:\scripts;

    I checked file association and the Path in Winnt Environment all seemed OK. I installed/uninstalled/reinstalled PERL few times and rebooted few times, all to no avail. So do you know where I can download the zipped version of this library or how can I sort this PPM problem please.

    Cheers.
      That is mongo strange.

      Have you tried giving it the full path? I.e.

      C:\Perl\bin\ppm

      Or, since it says that you do not have *Perl* in your path,

      C:\>perl -V

      Also, note that if you do get ppm to run, you may need to set the HTTP_PROXY variable for it as described in perldoc PPM


      --
      Regards,
      Helgi Briem
      helgi DOT briem AT decode DOT is

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://269153]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others admiring the Monastery: (5)
As of 2024-03-28 20:17 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found