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.
[reply]
      That is mongo strange.

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

      C:\Perl\bin\ppm

      [download]

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

      C:\>perl -V

      [download]

      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

[reply]
[d/l]
[select]
[reply]
[d/l]

In Section Seekers of Perl Wisdom