How to install Spreadsheet/ParseExcel/Simple.pm

[Vinod]

I'm getting the following error, I'm using AIX 5.1 server, do I need
to install these constructs from CPAN in order to use these constructs
Spreadsheet::ParseExcel::Simple. I'm new to pel scrpting, my queston
might be very basic but any help is appreciated.
Can't locate Spreadsheet/ParseExcel/Simple.pm in @INC (@INC contains: /
usr/opt/p
erl5/lib/5.6.0/aix /usr/opt/perl5/lib/5.6.0 /usr/opt/perl5/lib/
site_perl/5.6.0/a
ix /usr/opt/perl5/lib/site_perl/5.6.0 /usr/opt/perl5/lib/site_perl .)
at excel2t
ext.pl line 3.

[Wardy]

Hi Vinod

Yes, that means you haven't installed Spreadsheet::ParseExcel::Simple
from CPAN but somewhere in your program (either directly or in a
module you use) there's a
use Spreadsheet::ParseExcel::Simple;
somewhere.

~ Michael

[Vinod]

Hi Michael,

I have asked my unix sa's to install the package, and they said they
did, and I dod see this folder /usr/opt/perl5/lib/Spreadsheet-
ParseExcel-Simple-1.04 on my unix box, but I'm still getting the same
error, do i need to add the path to @INC, if i need to add the path to
@INC how do i do it.

Thanks,
Vinod

> > ext.pl line 3.- Hide quoted text -
>
> - Show quoted text -

[Ireneusz Pluta]

Vinod napisał(a):

> Hi Michael,
>
> I have asked my unix sa's to install the package, and they said they
> did, and I dod see this folder /usr/opt/perl5/lib/Spreadsheet-
> ParseExcel-Simple-1.04 on my unix box,

isn't that what you see in the path just a sort of a distrubution
package simply copied into Perl lib path, instead of being installed? As
far as I read from perl manuals, and also from what I see in my system,
you should rather see something like:
/path/to/perl/lib/Spreadsheet/ParseExcel/Simple.pm
So verify with your admins if they really installed the package in the
Perl way.

Or, alternatively install the package yourself locally in your home
directory, for instance in a subdirectory 'lib' and use `use lib "lib"'
in your script. `use lib' is the way to make @INC happy, and answers the
below question. Consult 'man lib' for more details.

[Vinod]

I had the same doubt, unix sa might have just copied the module, to
make @INC happy i added the new path to INC using
push(@INC, "/usr/opt/perl5/lib/Spreadsheet-ParseExcel-Simple-1.04/lib/
Spreadsheet/ParseExcel/"); but still getting the same error, so to
figure our if the sa installed it properly I used perldoc perllocal
and perldoc Spreadsheet::ParseExcel::Simple, none of these commands
show this module being installed. Can I confidently say to my unix sa
that he didnt install the module but instead copied the module.
If Simple.pm uses ParseExcel.pm in this case do I need to install the
Spreadsheet::ParseExcel module, also I see use strict in Simple.pm, my
guess is I should install strict.pm too, is this correct?
Thanks,
Vinod

> >> - Show quoted text -- Hide quoted text -

[Ireneusz Pluta]

Vinod napisał(a):

> I had the same doubt, unix sa might have just copied the module, to
> make @INC happy i added the new path to INC using
> push(@INC, "/usr/opt/perl5/lib/Spreadsheet-ParseExcel-Simple-1.04/lib/
> Spreadsheet/ParseExcel/"); but still getting the same error, so to

its definitely not that kind of the path, the proper pattern should be what I gave you before.
Anyway, if the module is installed properly in a system wide perl lib directory (one of the included
in @INC) then you don't need to do manipulate it.

> figure our if the sa installed it properly I used perldoc perllocal
> and perldoc Spreadsheet::ParseExcel::Simple, none of these commands
> show this module being installed. Can I confidently say to my unix sa
> that he didnt install the module but instead copied the module.

Then you prove the module was not installed and you may tell them that.

Tell them to run the following:
`cpan Spreadsheet::ParseExcel::Simple`
However, if they don't know Perl installation issues this may fail, as CPAN.pm might not be be
configured or even installed.

So, the other option is to:

cd a/temp/dir
wget http://search.cpan.org/CPAN/authors/id/T/TM/TMTM/Spreadsheet-ParseExcel-Simple-1.04.tar.gz
tar fxz Spreadsheet-ParseExcel-Simple-1.04.tar.gz
cd Spreadsheet-ParseExcel-Simple-1.04
perl Makefile.PL
make
make test
make install

which is more-less just a manual way of what cpan does.

If this is too difficult for them then do it yourself, with the exception of `make install`, instead
of which you find just built Spreadsheet/ParseExcel/Simple.pm tree and move it to your/own/perl/lib
directory which you then point in your script with 'use lib qw(your/own/perl/lib);'

I believe that there is a way to configure Perl to make it possible to have `make install`
installing both modules and manpages to a local user's subdirectories. It's definitely possible with
cpan utility, through its Config.pm module, but I don't know how to achieve that with the `make`
method. Can anyone in the group help?

> If Simple.pm uses ParseExcel.pm in this case do I need to install the
> Spreadsheet::ParseExcel module, also I see use strict in Simple.pm, my

Yes, because Spreadsheet::ParseExcel is not a standard Perl module.

> guess is I should install strict.pm too, is this correct?

No, it is already present in core Perl distribution, as well as many other pragmas and standard modules.